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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top