View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Annette[_3_] Annette[_3_] is offline
external usenet poster
 
Posts: 32
Default Move non date/add blank row

How can I programmically write, if a number is found in column 1 (A) that is
not a date, move over two columns and drop in column 3 (C).

Then the next step after looping the above is to insert a blank row above
each date found in column 1 (A) for all dates found.

Thanks.

Annette