May I ask how to write a search and replace macro, but instead of writing:
... may I ask how to independently read this "search" text into a string (hopefully a string that can handle 'more' than 255 characters per cell, even in Excel 2000) then replacing that search text("OldText") with ("NewText") step-by-step?
(Also pls. note that "OldText" can appear multiple times in one cell)
Thanks so much in advance!!