first blank column number: too difficult for a beginner...

[IgorDepecker]

Dear,

Can someone help me with the following:

In cell A1, I want the column number of the first blank column (= going right column by column) after the active cell;

example: row B is filled until and including column D; row C is filled until and including row F; row D is filled until and including B, ...
when active cell is B1, A1 should give me 5
when active cell is C1, A1 should give me 7
when active cell is D1, A1 should give me 3
...

Any help is welcome ! thanks a lot in advance
Igor

 

[HalfAce]

Re: first blank column number: too difficult for a beginner.

Yeah, well it's still a nice formula. :wink:

Dan