Count the number of rows in active cell's current column using VBA.

Hi

How do I count the number of rows (that are not blank) in my activecell's current column?

I have this so far:

Please Login or Register  to view this content.

I then need to take that value and put it here:

Please Login or Register  to view this content.

Originally Posted by tehneXus

Hi,

try it with the CountA function:

Please Login or Register  to view this content.

Regards

Sorry, that doesn't work.

A more detailed explanation of what I require:
Column A
Header
Value
Value
Value
Value
(blank)
(blank)
...
(blank)

The (blank) rows contain formula's whose output returns an empty cell.
I need the total number of rows that have stuff in them that exclude the header row.
So in this case, total rows = 4.

Please Login or Register  to view this content.

Hmm, I tried that but I get a run-time error 1004.

Originally Posted by tehneXus

Please Login or Register  to view this content.

Oh ok that makes more sense.
However, I think you somewhat misinterpreted me:

My "Values" are values that are derived from formula's in that cell. I mean that every row in each column has formulas in them but some of them return data and others return blank. I want the total number of rows that contain valid results.

If anyone is still interested, I figured it out:

Please Login or Register  to view this content.