Does the other solution not work regardless?

Actually, this means that the formula has a mis-spelt function, or refers to
an object (worksheet, name) that does not exist.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Les Stout" wrote in message
...
Sorry a correction to that it is putting "#NAME?" into the cell now, but
not overwriting the existing info.

Les Stout

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