Set Variable as Formula Result

[BigNate]

Hello Everyone,

When I run the following code, I get an error saying, "unable to get the match property...". Can someone please tell me what I am doing wrong?

Sub abc()


Dim Total As Integer


lastrow = WorksheetFunction.Match("8900", "B:B", 0)

Cell(lastrow,1).select


End Sub

 

[Stridhan]

you have to specify the range like activesheet.range("B:B") or other range else it wont valid the lookuprange

check your Dim as well and cells instead of cell

 

[BigNate]

Great, I have it working now, Thanks Stridhan!

 

[Stridhan]

you're welcome