Add data of same sheet with OFFSET

[sanjuss2]

I have this code which is showing an error
I want to copy L3 to S3 of sheet2 & paste it on the same sheet from A2:H2 & onwards because values in L3 TO S3 are getting changed at regular intervals, so I want to store the previous value.
So new value must be added in column A to H after previous value.
The error line in RED

Thanks in advance

Please Login or Register  to view this content.

[TMS]

What is in cell A3 (and below)?


Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file and a mocked up solution.

[sanjuss2]

PFA of file

Please Login or Register  to view this content.

[kvsrinivasamurthy]

Does the values changed manually. If so, worksheet event can be used to transfer previous data to range A2:H2 automatically. No necessity of macro run.
You can change this line

Please Login or Register  to view this content.

as

Please Login or Register  to view this content.

[TMS]

In the sample file provided, there is nothing below cell A1. Hence Range("A2").End (xlDown) will take you to the very last row in the worksheet. From that point, you cannot use .Offset(1,0) as it will take you beyond the limit of the sheet.

The solution in post #4 would not fail but it might not give you the range you want. You need to use a range that is fully populated. That is, has data in the last used row.

[sanjuss2]

Thank you it works... kvsrinivasamurthy
I will check it on my main file tomorrow...