Replace function

A

anandmr65

Hi,

I had done a VBA program and had used the "Replace" function in that &
it was working perfectly. Recently I had my Excel application
reinstalled. Now the Replace function is not working( not working means
it does not replace and no error is shown).

Could somebody enlightem me on who could have gone wrong when the excel
was installed. Should I enable any addins?

Quick reply will be of great help & highly appreciated.....Many users
are pouncing on me....:):)

Thanks for the help in advance

Regards
Anand
 
K

Kevin B

If you have an error handler that does a Resume Next, it would not
necessarily produce an error.

I would look to see what Excel libraries you have loaded. Press Alt+F11 and
in your VB Editor click TOOLS and then select REFERENCES. See what libraries
have been loaded for MS Excel.
 
Top