To tell the truth, I focused on what you asked - I wasn't looking for syntax
errors, so I missed the fact you had a bad range reference in your code and
I used you code as an example.

You are correct that you need to use the proper syntax to define your range.
However, I can't get the error you described until I fix the syntax error
and then use Application.Match. In that case, my suggestion allowed it to
work properly.

--
Regards,
Tom Ogilvy





"SIGE" wrote in message
...
Hi Tom,

I tried to get your solution to work ... I've too much respect to say
your solution is not correct. But working with XL97 SR2 you definitely
need to put

sige = Application.Match(1, Range("Sheet1!$A$1:$K$1"), 0)
instead of:
sige = Application.Match(1, "Sheet1!$A$1:$K$1", 0)

But it is working now!
Thanks a lot Bob and Tom!!!

Sige


"NOSPAM" to be removed for direct mailing...

*** Sent via Developersdex http://www.developersdex.com ***