View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Chris Hankin[_2_] Chris Hankin[_2_] is offline
external usenet poster
 
Posts: 8
Default Delete entire rows where there is a blank in column A

Hello,

Could someone please advise on a macro code that would do the following:

If there is a blank cell in column A, then delete the entire row . I
need this to loop around from A2:A60000.

Any help would be greatly appreciated.

Thanks,

Longbow :-)

Live Long and Prosper :)

*** Sent via Developersdex http://www.developersdex.com ***