IgorDepecker
New Member
- Joined
- Jan 8, 2005
- Messages
- 35
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
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