Have calculation set to Automatic?

--
Regards,
Tom Ogilvy

"Michael Smith" wrote in message
...

It's not a text string and isn't a format problem either. Here is the
kicker....if I manually go into the formula bar and click
enter...(Recalculating the formula)....the formula then WORKS!

Again, this macro and the formula within the macro works fine on my
computer, it is failing on another computer I installed it on.

Any ideas?!


*** Sent via Developersdex http://www.developersdex.com ***