Error finding string in a range of cells

[welchs101]

Hi,

I have the following code in my program. And it runs file....ie...no run-time errors generated.

When i change the 1 to a variable "lcntr1".......i get a runtime-error of type mismatch 13.

runs ok:

Please Login or Register  to view this content.

does not run ok:

Please Login or Register  to view this content.

lcntr1 is defined as a long variable type and has the value of 2............i dont get why this fails.......


any ideas? stumped on this one........or i have just been looking at this way to long

[AndyLitch]

Please Login or Register  to view this content.

[welchs101]

andy that does not work

I cut-n-pasted what you sent into the vba section and it highlights in red........letting me know the syntax is wrong.

thanks for trying though.........any other ideas?

[welchs101]

i still dont know the answer but found this as well

if take what does seem to work (see below):

Please Login or Register  to view this content.

and replace the 1 with a 2........then it does not work........

Please Login or Register  to view this content.

[tigeravatar]

lcntr1 is indeed the looping variable, however, in your code above you typed lctrl (the last character is a lowercase L instead of 1), which is an undeclared variable that has had no value assigned to it. Change the lowercase L to a 1 so that it is lcntr1 and it should work.

[welchs101]

tigeravatar, i tried what you suggested and it still did not work. can you attach an udpated file so i can look at what you did.......

[welchs101]

i think i figured it out...........it has to do with the "After:" section.

Recall, that it works with a 1........but not ANY number larger than this.........if you look at my "After:" section you see i specify cells (1,3)...........i changed this from 1,3 to 2,3 and i was able to get program to run for a value of 2 that had previously failed...........

i will write more once i confirm futher

[tigeravatar]

You can omit the After:= argument, there's no need to include it

[JosephP]

you're right-the after cell (if you specify one) must be within the search range or you will get that error

[welchs101]

thanks guys...........