assign the result of countif to a variable in VBA

**lima** · 09-21-2010, 06:37 PM

Hello all

I need some help with excel 2007 please.

How do I assign the result of the countif function to a variable in VBA instead of showing the result in a cell?

something like

loopcounter = "=COUNTIF(C[-6],""?*"")"

cheers

**shg** · 09-21-2010, 06:45 PM

It's a relative column reference, so it would have to be evaluated in the context of a particular column.

**lima** · 09-21-2010, 07:11 PM

Thanks shg

so apart from using something like loopcounter = activecell.value,
is there a way to write code that will count cells in a coloum that have some content and put the result into a variable

**TMS** · 09-21-2010, 07:28 PM

If you know which column you want to check, or which part of a column, and you know which cell holds the value you are looking for, you can have something like:

Please Login or Register  to view this content.

Or

Please Login or Register  to view this content.

Or

Please Login or Register  to view this content.

Regards

**lima** · 09-22-2010, 04:48 PM

Thanks TMShucks
I’ve spent hours trying to write something like any of these 3 lines without success

Come on you Reds, what a hat trick

Best Regards

**TMS** · 09-22-2010, 05:19 PM

Each to their own. I've been watching a professional tiler tiling my kitchen and thinking, "I wish I could do that".

Thanks for the feedback.

Regards