find the next empty row

[mark h]

Hi guys,
Can you help me?
I need to run a vb macro that will paste info into the
the next empty row/cell of a worksheet. Does anyone out
there know how I can do this?
Thanks
Mark

 

[Bob Umlas]

If you know it's column A, then:
ActiveSheet.Range("A65536").end(xlup).Offset(1).Paste '--assumes you've
already done the copy!

bob Umlas
Excel MVP