Copy dynamic range from previous sheet and paste after last used row in a range

Hello All,

I am trying to copy the values from a dynamic range ("C7:E66")on the previous sheet onto the current active sheet, but I need to paste the values after the last used row in a range ("C7:E66")

I can get it to copy the data on the previous sheet no problem, however I am stuck as it is not pasting after the last used rown on the active sheet that the macro is run from.

Here is what I have so far

I appreciate any help offered greatly as I'm pulling my hair out now!

Please Login or Register  to view this content.

Originally Posted by Mistweaver

Hello All,

I am trying to copy the values from a dynamic range ("C7:E66")on the previous sheet onto the current active sheet, but I need to paste the values after the last used row in a range ("C7:E66")

I can get it to copy the data on the previous sheet no problem, however I am stuck as it is not pasting after the last used rown on the active sheet that the macro is run from.

Here is what I have so far

I appreciate any help offered greatly as I'm pulling my hair out now!

Please Login or Register  to view this content.

Hi,

Not sure if this is what your looking for but maybe try:

Please Login or Register  to view this content.

Thank You, Mike

Originally Posted by snb

Do not use relativer references to sheets in VBA.

Please Login or Register  to view this content.

Thanks snb, but the reason I am using relative references is that the number of sheets will change weekly and so I cannot use the index number.

Mike,

Thanks for helping, but this does not work. It pastes much further down the sheet instead of after the last used row in range C7:E66 which is where I need to paste the data.

The last added sheet is always sheets(1)
the oldest (first) sheet is sheets(sheets.count))
than this will do

Please Login or Register  to view this content.

I still haven't had any luck with this so any more help would be greatly appreciated.

I have attached the workbook.

Basically I need to copy the figures from the sheet before to the sheet next to it after the last row of data.