replacing TRUE/FALSE

R

Rogueuk

I got around this by adding to my macro and doing a find/relpace.
That seemed to do the job.
Thanks for any help

Selection.Replace What:="TRUE", Replacement:="YES", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False
_
ReplaceFormat:=False
Selection.Replace What:="FALSE", Replacement:="NO", LookAt:=xlPart
_
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False
_
ReplaceFormat:=False
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

find and replace multiple values in one statement 3
Macro Not Changing Date Values 7
Find and Replace is going wrong in some cases 10
Tidy up multiple find and replace code 2
Word macro that can call cells out of Excel for a find and replace 0
Macro to select columns and replace data 0
Find text, replace it but now I need to change the height of allpreceding/following text 10
Select Text to End of Footnote 9

Top