Need to find next empty cell in column B

D

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.
 
B

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.
Click to expand...
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)
 
Top