Run-time error 1004 - Unable to get the match property of WorksheetFucntion lass
I keep getting a runtime error but I do not know why. It is giving me a Run-time error 1004 "Unable to get the Match property of the WorksheetFunction class." It highlights a variable that I try to define. I copy/pasted the match criteria, so I know it is accurate.
Anyone have an idea of what's wrong?
Please Login or Register to view this content.
Which worksheet are you meant to be looking in?
If posting code please use code tags, see here.
the name of the worksheet is called ("Mod")
Does this work?
Please Login or Register to view this content.
Ok cool. If I had to declare a bunch of i variable from the same sheet, would it make more sense to use a "With...End With" statement?
How would you use With for a variable?
Just to define them all at once:
Please Login or Register to view this content.
That won't work.
Try this.
PS What's rngData for?Please Login or Register to view this content.
okkk so I'll just get rid of the .activate. The rngData was for something else that I was trying, but it doesnt seem necessary anymore. Thank you for your help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks