Hi,
I had done a VBA program and had used the quot;Replacequot; function in that amp;
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 amp; highly appreciated.....Many users
are pouncing on me....:-)
Thanks for the help in advance
Regards
Anand--
anandmr65
------------------------------------------------------------------------
anandmr65's Profile: www.excelforum.com/member.php...oamp;userid=30728
View this thread: www.excelforum.com/showthread...hreadid=540592If 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 Backmannquot;anandmr65quot; wrote:
gt;
gt; Hi,
gt;
gt; I had done a VBA program and had used the quot;Replacequot; function in that amp;
gt; it was working perfectly. Recently I had my Excel application
gt; reinstalled. Now the Replace function is not working( not working means
gt; it does not replace and no error is shown).
gt;
gt; Could somebody enlightem me on who could have gone wrong when the excel
gt; was installed. Should I enable any addins?
gt;
gt; Quick reply will be of great help amp; highly appreciated.....Many users
gt; are pouncing on me....:-)
gt;
gt; Thanks for the help in advance
gt;
gt; Regards
gt; Anand
gt;
gt;
gt; --
gt; anandmr65
gt; ------------------------------------------------------------------------
gt; anandmr65's Profile: www.excelforum.com/member.php...oamp;userid=30728
gt; View this thread: www.excelforum.com/showthread...hreadid=540592
gt;
gt;
- Aug 28 Tue 2007 20:39
Replace function
close
全站熱搜
留言列表
發表留言