Thread: Non blank cells
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
MrRJ MrRJ is offline
external usenet poster
 
Posts: 109
Default Non blank cells

Hello,

I need you help in resolving my error code. I would like to find the first
blank cell in colume A and then delete everything below it.

I tried this and it did not work.
Range(Range("A65536").End(xlUp)(2), Range("A65536")).EntireRow.Delete

Help is much appreciated.