Thread: VB code for selecting all rows below filled column
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
  
Posts: 11,123
Default VB code for selecting all rows below filled column
Hi KelliInCali

Try this

Dim lr As Long
lr = Range("B" & Rows.Count).End(xlUp).Offset(1, 0).Row
Range("A" & lr & ":IV" & Rows.Count).Delete


--
Regards Ron de Bruin
http://www.rondebruin.nl



"KelliInCali" wrote in message ...
Hi. I need to delete data in all the rows below the last filled row for
column B. Can anyone give me code for that? Thanks in advance, Kelli


Reply With QuoteReply With Quote