Re: Changing Code Modules, PLEASE HELP ASAP!! PART 2
- From: Edward Ulle <eulle@xxxxxxxxxxx>
- Date: Tue, 31 Jan 2006 11:36:54 -0800
Brett,
It would seem to me you need to loop through myFStr to compare with each
value in ReplacecodeInModule the line
If InStr(1, myCode, myFStr(i)) > 0 Then
You say you declare but don't set i. I don't see that in your code.
Unless there is an i declared as a global variable i will be 0 and only
the first value of myFStr will compare. With Option Explicit unless i
is global the compiler would complain about i in ReplacecodeInModule.
*** Sent via Developersdex http://www.developersdex.com ***
.
- Prev by Date: Re: Deleting rows, multiple column criteria
- Next by Date: adding content to a cell
- Previous by thread: Re: Changing Code Modules, PLEASE HELP ASAP!! PART 2
- Next by thread: Maximize Excel ***
- Index(es):
