Count number of cells

[skatmandu2002]

Hiya,

Just wondering if there is a function that can count the number of cells in a range?

for example, if cells A1:C3 are merged, this would count as ONE cell.

Thanks, have a nice day

[Leith Ross]

Hello skatmandu2002,

There isn't a built-in function for this. Here is a UDF macro...

Please Login or Register  to view this content.

Sincerely,
Leith Ross