ExcelBanter - Find next open row in a column

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Find next open row in a column (https://www.excelbanter.com/excel-programming/398552-find-next-open-row-column.html)

Eric

Find next open row in a column

Hello all,

I am trying to paste information into the last open rown of a column. I am
stuck. Can anyone please help.... THankyou.

Eric

Tom Ogilvy

Find next open row in a column

Dim r as Range
set r = cells(rows.count,"F").End(xlup)(2)
r.PasteSpecial xlPasteAll

--
Regards,
Tom Ogilvy

"Eric" wrote:

Hello all,

I am trying to paste information into the last open rown of a column. I am
stuck. Can anyone please help.... THankyou.

Eric

All times are GMT +1. The time now is 09:03 AM.