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

--
HTH...

Jim Thomlinson


"Filips Benoit" wrote:

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