CODEWITHSUNDEEP
vbaexcel
user1525612
user1525612

Reputation: 2024

Find and go to last row in column

I have the following sheet. Rows are not a fixed number and can vary.

enter image description here

I want to select one cell below the last row in column B. It will always be column B, but sometimes there are more rows.

enter image description here

I am just starting off with VBA and macros, so not much effort from my side to show, apologies.

Thanks!

Upvotes: 0

Views: 2792

Answers (1)

Pearli
Pearli

Reputation: 159

Dim Rng As Long
Rng = Cells(Rows.Count, 2).End(xlUp).Row + 1
Cells(Rng, 2).Select

The variable Rng contains always the row number of the last cell in B plus one row.

Upvotes: 2

Related Questions