Can we see the formula?

Have you tried [F9] - not automatically refreshing, but might work and it
would be a one-key-click solution.

"Ted" wrote:

i have a formula that counts cells that have been highlighted.
But I have to redrag it to get it to refresh after I highlight cells...
can someone tell me how to get it to automatically refresh after I highlight
cells?

Please help...
Thanks