Error using Match method of WorksheetFunction

Hello,

I'm trying to use the Match property to find a value in a list and I am getting a run-time error that I have not been able to solve.

Run-time error '1004': Unable to get the Match property of the WorksheetFunction class.

The syntax I am using is the following:
GralesGuia(1) = Range("C8").Value
'Identificar Row de la guía solicitada en pestaña Datos
Set RangoGuias = Worksheets("Datos Guias Carretera").Range("A3:A500")
RowGuia = WorksheetFunction.Match(GralesGuia(1), RangoGuias, 0)

I also tried "Application.Worksheets("Datos...
but I get the same error.

I would be verry thankful if someone could give me a hand.
I know I can do this with a loop but I would like to learn how to use the WorksheetFunction methods.

Thanks!

szepeda.

Hello,

I did not declare the types of both GralesGuia and RowGuia so they are Variant.
GralesGuia is a vector of 13 elements.

Here is the syntax I used to declare them:
Dim RowGuia
Dim GralesGuia(13)

Each cell of A3:A500 of 'Datos Guias Carretera' contains either an integer value that tags the "Trip Number" that is contained in the given row or is empty.

Thank you very much for your help.

I am new in this and do not know what is a "code tag"; if you could please clarify what it is so that I can include them in my future posts.

szepeda