Finding text and replacing in VBA
Dear All,
we have a pricing template that some turkeys decide to include text in
it when filling it out.
How can I find and replace ANY text that appears in the range? The
variance of entered text is huge, so there is no way to find and
replace specific text.
We want to replace any text with a zero ("0").
Basically, we need to go from cell to cell, find an instance of text,
then replace it with zero.
Help would be greatly appreciated...
Regards,
andym
|