Thanks for all the replies however I was trying to avoid macro's as the
end user can disable them.

Maybe there's a different tact I can use.

I've got a table of True or False answers. A few lines will return a
error as there are some unknowns which will be amended by the user to
True or False

I tried to format using the IsText function but unless the user enters
a ' at the start it see's it as a logic statement.

Any other ideas ??

VBA Noob


--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=563079