Function only working with string variable

[Evilbungle]

Hi,

I have created a Function in VBA for looking up a value in a grid it works fine but only if I place the Range as a string and I really need to be able to just select the cells as you would with a standard function.

Here is my Function

Please Login or Register  to view this content.

Vlookup is the Value to find at the Left, Hlookup is the value to find at the top and GArray is the Range to look at.

Like I say it will work with Glookup(2003,2003,"A1:G10") but I need it to work with Glookup(2003,2003,A1:G10)

Any help would be great,

Thanks

[romperstomper]

Try this:

Please Login or Register  to view this content.

[Evilbungle]

Thanks, That works great.

Thought I had almost cracked it but clearly i was miles off.

[romperstomper]

There's always more than one way to do something in Excel, so you may have been close - I just choose the path of least resistance generally!

Please don't forget to mark your question Solved.