I am designing a spreadsheet using macros in which I want to copy a range of cells from one sheet and paste to another. I am able to do that part but what I want to do is to find the way that the macro recognizes the first set of cells is already with data then should paste to the next one. I will appreciate any suggestion.

JorgeAE, This will select the cell below the last cell with data in column
A, is that what you need?

Cells(Rows.Count, 1).End(xlUp).Offset(1, 0).Select

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"JorgeAE" wrote in message
...

I am designing a spreadsheet using macros in which I want to copy a
range of cells from one sheet and paste to another. I am able to do
that part but what I want to do is to find the way that the macro
recognizes the first set of cells is already with data then should
paste to the next one. I will appreciate any suggestion.


--
JorgeAE