Need to find next empty cell in column B

[Dbl_Planker]

Hello,

I'm not sure if this is the right discussion group, but this is an Excel
project that is requireing some VBE coding.

I need to find the last empty cell in column B to start my data entry. The
code that I'm currently using is based on the last empty cell in the far
left, column A.

lRow = ws.Cells(Rows.Count, 1) _
.End(xlUp).Offset(1, 0).Row

I need to have this based on the next column over (B).

I would appreciate any suggestions.

 

[Bob Greenblatt]

Hello,

I'm not sure if this is the right discussion group, but this is an Excel
project that is requireing some VBE coding.

I need to find the last empty cell in column B to start my data entry. The
code that I'm currently using is based on the last empty cell in the far
left, column A.

lRow = ws.Cells(Rows.Count, 1) _
.End(xlUp).Offset(1, 0).Row

I need to have this based on the next column over (B).

I would appreciate any suggestions.

This is an Excel for Macintosh forum. Excel for Macintosh does not have VBA
in this version. However, the answer to your question is to change the
offset in the above code from (1,0) to (1,1)

 

[Shane Devenshire]

Hi,

You could use

lRow = Range("B65536").End(xlUp).Row+1