MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Macro Question

Posted by Buck on February 15, 2002 12:49 AM

In a macro: after inserting a row, then copying a
named range... how can I get it to always paste in the
empty row just inserted OR allow me to choose where
to paste the data? When running the macro more
than once, it always wants to paste back in the row
it did the first time. I figure this is an easy fix,
but I'm just drawing a blank. Any help would be
greatly appreciated. Thanks!


Posted by JohnG on February 15, 2002 6:04 AM

dim Floop as int
Sub pp()
For Floop = 1 To 5
Range("a" & Floop).Insert
Range("a" & Floop).PasteSpecial
End Sub