<!-- TOC -->
I'm new to macro - so don't laugh... I'm trying to copy Cells A1 and B1 from 400 worksheets to a single worksheet (Merge). The following macro code copies and pastes the cells but overwrites each time the macro is run.
How can I tell the system to paste in the next blank row?
' Macro5 Macro
You can use this:
Thanks to Excelguru
for this tip on the forum.
Published by aakai1056
Latest update on January 24, 2010 at 10:54 AM by aakai1056.