Depending on what you're doing you may also want to check
that the first character is an "="

Regards,
Peter


Hi
e.g. try
msgbox application.evaluate("=A1+A2")

--
Regards
Frank Kabel
Frankfurt, Germany


Adrian wrote:
Hi,
Do you mind explaining in detail ?
Thanks.

Hi
try using Application.evaluate for this

--
Regards
Frank Kabel
Frankfurt, Germany


Adrian wrote:
Hi,

How do you check in VBA code that a string is a
valid formula ?
Thanks.

.