Need to Count Blank cells from active cell going UP the same column

In my active cell I need the count of blank cells in the same column moving UP from the active cell. The position of the active cell will be different each time I run the macro. I can identify the active cell but I don't know how to input the countblank formula for that range going up the column....

Hi

how about

Please Login or Register  to view this content.

rylo

Hi and thanks. This works but I need to see the result in my active cell rather than the message box....

Hi

Please Login or Register  to view this content.

rylo

Excellent. That's what I needed. Many thanks.