increment row number using variable

Hi AB33,

suggested code line working fine,

but on the first run of macro - result is pasted from Row-A2 when RowA1 is blank row.
And subsequently code works fine by find the last row and offsetting the row.

------
Additionally
Can u help me how the code works in case of 'FIND METHOD' code posted in #1
(Range.Find Method - using the loops).