Apply formula to variable

[roro]

I am looking to run a formula and instead of returning a result within a cell, have it return the result in a variable I have declared. Example below:
I am trying to match a value and then return that value into my variable "totrow". The formula works if I attach it to a cell, but the syntax is wrong if I try to use it in VBA.

Dim totrow As String
totrow = MATCH(A1,Sheet1!A1:A13,0)

BTW, thanks to all those that take the time to respond to all us newbies, you make this an awesome forum and provide so much help to us. Much appreciated!!

 

[martinee]

Generally, you have to do something like:

Application.WorksheetFunction.Match....

Please note that the referencing process changes slightly. HTH.

 

[roro]

Tried this but it gives me a syntax error still.

totrow = Application.WorksheetFunction.Match(A1,A1:A13,0)

 

[roro]

I found the problem. I had to tell VB that it was a range. That was the difference in using it in VB versus physically applying it to a cell.

totrow = Application.WorksheetFunction.Match(Range("A2"), Range("SAP!A1:A13"), "0")