Offset in Custom Function Problem 1

[bigz60]

Hello. I am trying to create a custom function that uses the offset function. I am creating this to eliminate some of the input parameters, which will allow the end users to only have to input two parameters (the rows and cols params).

Here is my function:

Public Function roff(x As Integer, y As Integer)


roff = WorksheetFunction.Offset(January, x, y, 1, 1)

End Function

January is a named range in the worksheet.

When I try to enter the roff function with the two params, i get the dreaded #VALUE.

I am not sure where to go from there.

 

[Anthony047]

The top inconsistency is that Offset is NOT in the list of WorksheetFunctions available from Vba (check the help on line).

Try this:

Public Function roff(x As Integer, y As Integer)
roff = Range("January").Range("A1").Offset(x, y).Value
End Function

Bye.


Anthony047 (GMT+1)

 

[bigz60]

Thank you Anthony. That works perfectly.