Paste into next blank row macro

[Badvgood]

Hi all,

I need to write a macro that copies some data from sheet 1 and pastes it into sheet 2 but in the next free reow in sheet 2.

The bit I am stuck with is how to get the data uinto the next free row in sheet 2.

What command do you use to make it go to the next free / blank row?

Regards BVG

[royUK]

This has been covered so many times on the Forum, a quick search would save you time.

See the contacts form example here

http://excel-it.com/vba_examples.htm