Next cell after Last Used row - VBA Excel

[KNKN9]

Hi,

I currently have the code

Cells(Rows.Count, 2).End(xlUp).EntireRow

And this selects the last row with data. However, I want to use a code similar to offset, I want to select the next row after the last row with data. Similar to what i have for last used column

Dim LC As LongLC = Cells(7, Columns.Count).End(xlToLeft).Column
Columns(LC).Copy
Cells(1, LC + 1).PasteSpecial

Thanks,
N.

 

[mumps]

This will copy cell B1 to the next row after the last row with data in column A:

Sub test()
    Range("B1").Copy Cells(Rows.Count, "A").End(xlUp).Offset(1, 0)
End Sub

 

[KNKN9]

Thanks!

 

[mumps]

You are very welcome.