in the excel file im working on, i need to search and delete all the
commas occuring anywhere within the worksheet. how should i go about it
using a macro?

Turn on the macro recorder and then do Edit=Replace and enter the comma in
the find what and leave replace with blank.

Then turn off the macro recorder. Look at the recorded code.

--
Regards,
Tom Ogilvy


"ruchie" wrote:

in the excel file im working on, i need to search and delete all the
commas occuring anywhere within the worksheet. how should i go about it
using a macro?

u know what Tom.. u solved huuuge amount of problems for me by this
suggestion! thanks!!!