View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
MCheru MCheru is offline
external usenet poster
 
Posts: 70
Default Copy Paste Down Macro

I am trying to create a macro that will search A3:G100 for blank rows. When
a blank row is found, I want the macro to copy the contents in the cell above
it A(blank):G (blank) and paste those contents in each blank row going down
((A(blank):G (blank)) until the next row with contents is reached. Is that
possible?