View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Error when running VBA Help's Find method example

I actually meant that you could do the replace all in your code.

IanKR wrote:

<<snipped
And if you're doing this for a real reason, using a "replace all" would be
quicker than looping.


Many thanks for your quick reply, Dave. Yes - I shall be declaring all
variables in my project, and the whole thing will be "locked down", thereby
not allowing the user to do any Find/Replace from the UI. At the moment (but
it's early stages) I don't think I'll be using Find/Find Next code
elsewhere, but if I do, I shall specifiy all the parms as you say - I'd
noted this from the Help.
Thanks again.
Ian


--

Dave Peterson