Mark
08-06-2007, 06:22 AM
Good Morning All,
I am a rookie at VBA and excel macros and I am hopeful someone can help me with a question. I have searched the forum for an answer to my problem but have not come across it yet. That's why I am asking the question here.
I know the code to select that last cell in a range (if the cell is different every time) is: Range(Selection, ActiveCell.SpecialCells(xlLastCell)).Select
What code to I add to this if I want to then go to the next row and move all the way to column A?
Basically what I am trying to do accomplish is merge data from multiple worksheets into one worksheet, pasting the new data at the end of the previous data. I hope that makes sense.
So it's like hitting ctrl-end, the enter key, and then the Home key.
Any direction is greatly appreciated.
Have a great day.
Mark
I am a rookie at VBA and excel macros and I am hopeful someone can help me with a question. I have searched the forum for an answer to my problem but have not come across it yet. That's why I am asking the question here.
I know the code to select that last cell in a range (if the cell is different every time) is: Range(Selection, ActiveCell.SpecialCells(xlLastCell)).Select
What code to I add to this if I want to then go to the next row and move all the way to column A?
Basically what I am trying to do accomplish is merge data from multiple worksheets into one worksheet, pasting the new data at the end of the previous data. I hope that makes sense.
So it's like hitting ctrl-end, the enter key, and then the Home key.
Any direction is greatly appreciated.
Have a great day.
Mark