MrExcel Publishing
Your One Stop for Excel Tips & Solutions

NEED HELP IN MODIFING MACRO FOR FIND AND REPLACE


Posted by YANECKC on August 15, 2001 5:12 PM

: I CREATED A FIND AND REPLACE MACRO . THE ONLY PROBLEM IS THAT I WANT THE VALUE THAT IS REPLACED ALWAYS TO BE TEXT.


Posted by Robb on August 15, 2001 5:56 PM

Yaneck

Try formatting the cell before replacing the value. Your code would include a format line e.g.:

ActiveCell.NumberFormat = "000000000" 'Or whatever to give the required number of leading zeros
:

Does this help?

Regards

Posted by yaneckc on August 16, 2001 1:49 PM

Try formatting the cell before replacing the value. Your code would include a format line e.g.

No . What I need is even though it looks like number I want to overlay those numbers into text.
Is there a code ActiveCell.text. If so how do I finish that statement.

yaneckc