Calculate formula for only active cells

[Canine]

Hi all,

I have a formula in a cell which references a range of cells from a column. It works fine.

I need to filter this column sometimes, and want the formula to be re-calculated only for the active cells.

Is this possible? Any help is greatly appreciated. It's kind of urgent.

 

[pgc01]

Since there's only one active cell on a worksheet at a time I guess you mean the visible cells.

Check the Subtotal() function.

Remark: it's easier if you post the formula, we'll be able to understand the problem better.

 

[Canine]

u r right..i meant the visible cells only

The formula is to calculate the unique count of cells...

i will try and let u know if it worked..