MrExcel Publishing
Your One Stop for Excel Tips & Solutions

easy macro help needed... Select Range


Posted by Daniel P on August 18, 2000 12:03 PM

I'm trying to record a macro that will copy data that is on one tab and dump it into another.

During the recording process I start by selecting row 2 and then do the hold shift, press end, then the down arrow key to highlight everything. I copy, change tabs, hit end and down arrow, hit down arrow again and select that row and insert cells.

The problem is that the macro records actual cell addresses. Can someone give me the commands for this operation?


Posted by Daniel P. on August 21, 0100 5:49 AM

Thanks Ivan. Know of any "beginners" book for writing macros in Excel?

D

Posted by Celia on August 21, 0100 6:52 AM

Posted by Ivan Moala on August 18, 0100 2:16 PM


Try;
Range(Rows(2), Rows(2).End(xlDown)).Select


Ivan

I'm trying to record a macro that will copy data that is on one tab and dump it into another. During the recording process I start by selecting row 2 and then do the hold shift, press end, then the down arrow key to highlight everything. I copy, change tabs, hit end and down arrow, hit down arrow again and select that row and insert cells. The problem is that the macro records actual cell addresses. Can someone give me the commands for this operation?