View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] [email protected] lowrey_nor@hotmail.com lowrey_nor@hotmail.com is offline
external usenet poster
 
Posts: 1
Default remove all blank or empty rows

I'm new to VBA and I'm working on a project and leaning it
as I go. I'm at that point where I think I need a loop
that will loop through the rows and remove all blank or
empty rows. The worksheet will have a varying number of
rows and my have 1 to 4 blank or empty rows in a row (or
together)

Thanks to all who read this. Thanks to all who replay