VBA-Worksheet Function

[WindsorKnot]

Hi,

I'm having trouble with the one part of my code

I'm trying to basically do a Vlookup in a VBA Function, but I can't seem to get it right as I get the #VALUE! Error. Any guidance would be appreciated.

Thanks!

Public Function NetCostEE(FAverageCost As Variant)
    ' Define the data Parameters
    Dim R1 As Range
    Set R1 = Sheets("Mig").Range("F20:G50")
    NetCostEE = WorksheetFunction. _
       VLookup(FAverageCost, Range("R1"), 2, False)
End Function

 

[phxsportz]

Since you set R1 as a Range, there's no need to further declare it in the VLOOKUP statement

Public Function NetCostEE(FAverageCost As Variant)
    ' Define the data Parameters
    Dim R1 As Range
    Set R1 = Sheets("Mig").Range("F20:G50")
    NetCostEE = WorksheetFunction. _
       VLookup(FAverageCost, R1, 2, False)
End Function

 

[WindsorKnot]

Awesome Thanks