View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Constantly Amazed Constantly Amazed is offline
external usenet poster
 
Posts: 41
Default Auto insert blank rows

Hi

I have to repetitively handle a file with a list of reference numbers in
column A. The number of rows varies each time the task is carried out. The
rows are a continuous list. It is necessary to insert a blank line between
each row containing an entry. Could anyone provide a macro which establishes
how many rows there are in the list and then automatically inserts a blank
row between each entry?

Thank you for any assistance.

G