find the next empty row

  • Thread starter Thread starter mark h
  • Start date Start date
M

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
 
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
 
Back
Top