May I say you haven't provided all the information. What is this about a
macro? What is in a worksheet formula and what is in a macro and how is the
macro activated? What are the input values, how did you prove it is not a
string and not a formatting problem, what results did you expect and why and
what did you get instead?

--
Kind regards,

Niek Otten

Microsoft MVP - Excel

"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 ***