Writing Function using vlookup

[perdben]

Hi,

I'm trying to write a simple funtion (my first!).

Function is:

Please Login or Register  to view this content.

There is no problem with the vlookup range etc. I get a #VALUE. Any help would be great!

Thanks,
Ben.

[Paul]

Hi Perdben, welcome to the forum. Please take a moment to read our forum rules. In the future, please wrap your code using the # button in the post editing window. I've done it for you this time, but future posts may be locked.

As for your issue, when referring to a named range, use Range("Your_Named_Range"), qualify the variable types you're passing to the function, and use Application.WorksheetFunction.[some_function_here].

For example:

Please Login or Register  to view this content.

Be sure to put this into a standard Module, not in your Worksheet or ThisWorkbook code window.

[perdben]

OK, that worked well. Thanks very much!