How To Copy & Paste Data From One Tab To A Certain Cell In Another

**The_Snook** · 12-20-2011, 10:56 AM

Hi,

I'm trying to copy and paste data from one tab to the first empty row below existing data on another tab. My problem occurs at the red text below. I don't want to paste the copied data into cell 'A3110' that just happened to be the next free cell below the existing data when I recorded the macro. How can I amend it to achieve what i'm after?

Please Login or Register  to view this content.

Thanks in advance,

Snook

**watersev** · 12-20-2011, 11:08 AM

hi The Snook, sort of that basing on your code

Please Login or Register  to view this content.

**The_Snook** · 12-21-2011, 08:57 AM

It works a treat but i'd be grateful if you (or someone else) could explain to me why? I'm new to VBA but keen to enhance my understanding.

Please Login or Register  to view this content.

Thanks,

Snook

**watersev** · 12-26-2011, 06:16 PM

hi Snook, merry xmas and best wishes.

The whole Range(...) defines range of cells.
"a2" means the left upper range cell the range starts from
Cells(2,1) equals to A2 or R2C1
End(xlToRight) means go to the right from Cells(2,1) until the first empty cell met
offset(1) means offset one row down. So range("a1").offset(1) gives you range("a2")

Try to experiment with that on a sheet with data. Replace copy to select for study purpose to visualize what is going on. However avoid using Select in the code.

Hope that helps