A way to count cells in a range containing text or formulas

M

Michael Lanier

I need to be able to count the number of cells in a range that contain
formulas and text; a way of counting anything within a cell including
a null ("") return value. The range might be something like A1:Z100.
Some of the cells within the range will be merged. Can you suggest a
macro or formula (even better) for this. Thanks for your help in
advance.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA set thick borders around non empty cells in range 0
How to Select A Cell in VBA with a Variable Row Number? 3
VBA over-write identical worksheet-ranged-cells only if receiving sheet's cell is empty 4
populate cells within merge area 5
Keeping formulas on an insert 1
Count cells containing text, multiple criteria 2
using excel formulas in VB coding 4
Count If query within string 1

Top