Hi All,
I need a code that count the cells all the way down until the first non blank cell.
Activecell
Blank
Blank
Blank
NonBlank
So in this way I need 3+1 that is 4
I need this with active cell so I can refer this number in the code later like
X= VBAcode (i got the number here)
and later
If X = 4 then and so on
Can somebody help me with this?
Thank you in Advance,
Philip
I need a code that count the cells all the way down until the first non blank cell.
Activecell
Blank
Blank
Blank
NonBlank
So in this way I need 3+1 that is 4
I need this with active cell so I can refer this number in the code later like
X= VBAcode (i got the number here)
and later
If X = 4 then and so on
Can somebody help me with this?
Thank you in Advance,
Philip