Thread: VB code for selecting all rows below filled column
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bernie Deitrick Bernie Deitrick is offline
external usenet poster
  
Posts: 5,441
Default VB code for selecting all rows below filled column
Kelli,

Range(Range("B65536").End(xlUp)(2), Range("B65536")).EntireRow.Delete

HTH,
Bernie
MS Excel MVP


"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