Hi All,
I need to replace the text "NS" from all the cells in all the worksheets of an Excel workbook. I wish to design a macro that can help me do this along with the use of something that would allow me to do the "Find Whole Word" option similatr to the one we have in MS Word.

A probable way could be to wrap spaces around the word: " NS " (but that'll have
trouble with " NS.", " NS, "--any punctuation. But this is still acceptable.


Please can someone help.
Thanks,
Lonely