Find

  • Thread starter Thread starter Filips Benoit
  • Start date Start date
F

Filips Benoit

Dear All,

How can i find the columnnumber of the first empty cell starting from cell
M7

To be used in a loop. M is fix but 7 is variable.

Thank³

Filip
 
You can try this. It heads left from column IV back until it runs into the
first populated cell and then move one column to the right...

dim lngLastColumn as long

lngLastColumn = cells(7, columns.count).end(xlToLeft).offset(0,1).Row
 

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

Similar Threads

Get Range object from Cell Row and Column No. 1
Iteration 2
Very slow Excel Macro 19
update all hyperlinks to another drive 1
Usage of SUMIF formula in the VBA code 2
ResetAllPageBreaks 4
Programatic access to VB-editor not trusted 2
Disable inserting or deleting row in selection of rows 4

Back
Top