Finding the last row

[Mike_e]

Hi, I'm looking to establish the next empty row for a list that starts at B12 on sheet1. This is the code I'm using

Please Login or Register  to view this content.

For some reason I keep coming back with an empty result. Can anyone help please?

Many thanks in advance

Mike

[zbor]

Looking for last row (in title) or next row? That can be different things.

Try this for last row:

Please Login or Register  to view this content.

[AB33]

Mike!

Please Login or Register  to view this content.

Need to remove Row
You could use this code, provided that you have data populuated unitl B11.

Please Login or Register  to view this content.

[Marcol]

Try

Please Login or Register  to view this content.

[Mike_e]

Many thanks for your help guys. All sorted now!!