Excel Daily News

easy macro help needed... Select Range

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?

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?

(8 responses) I have a column with either a value of 1 or blank. The sheet has a header. Is there code that can sort by value in column "Z", find the last

Let's Connect

MrExcel.com debuted on November 21, 1998.

MrExcel.com provides examples of Formulas, Functions and Visual Basic procedures
for illustration only, without warranty either expressed or implied, including
but not limited to the implied warranties of merchantability and/or fitness for
a particular purpose. The Formulas, Functions and Visual Basic procedures on this
web site are provided "as is" and we do not guarantee that they can be used in all
situations.
This site contains affiliate links. Any affiliate commissions that we
earn when you click a link to Amazon or other sites is reinvested in keeping MrExcel.com
running. You can earn a commission for sales leads that you send to us by joining our
affiliate program.
View our Privacy Policy, Cookies Policy, and Terms of Use.