Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Using Error handling with the Find Method | Excel Programming | |||
Type mismatch error in Find method | Excel Programming | |||
Error when use find method in vb6 | Excel Programming | |||
Error Trapping the Find method | Excel Programming | |||
Run Time error '1004' when running Calculation method | Excel Programming |