Help with match function

Hi everybody,

I am trying to use the match function... The code is as follows:

Please Login or Register  to view this content.

I get an error - Runtime error 1004, application-defined or object defined error.
I think that the issues the range (matchrng) since this is the only variable that I can't see what it is when I hover my mouse over it.

What am I missing or doing wrong?

Thanks for any advice

TL33

What is k equal too?

Hi John,

k is a variable used in a for loop. Sorry for not including the for loop, it completely slipped my mind

TL33

I think we need too see more of your code, including the definitions of your variables too be able to help.

Here is the code:

Please Login or Register  to view this content.

Thank you so much for taking the time to help me

TL33

You need to declare your variables

Please Login or Register  to view this content.

Hi John,

Even if I declare the variables, the same error occurs. Will you please look at the attached file, it contains my code.
The problem is in the reporting macro.

Thank you so much for you help thus far

TL33