Replace function

[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

[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.
--
Kevin Backmann


"anandmr65" wrote:

>
> 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
>
>
> --
> anandmr65
> ------------------------------------------------------------------------
> anandmr65's Profile: http://www.excelforum.com/member.php...o&userid=30728
> View this thread: http://www.excelforum.com/showthread...hreadid=540592
>
>