Command to assist with copying new data

Hi,

Apologies for another simple question!

Can someone please tell me the statement to go to the row below the last row in a worksheet.

For example if I have a worksheet with data in cells A1:Z99, I want my macro to automatically go to cell say A100 and copy data into that cell and below. Most of this I can work out, but when I run my macro it keeps copying data to a previous cell. I want to run this macro and keep adding new data to existing data (ie below the existing data), rather than copying over the top of the existing data.

Thanks in advance.

Mr N

Use the offset property of a range.

Please Login or Register  to view this content.

The numbers in parentheses are (row,column). Positive numbers with move right or down, negative numbers move left and up.

That's perfect dangelor. Thanks for taking the time to respond, much appreciated!