How to use a Defined Name in VBA

[Elomaldo]

Hello,

I am trying to use Range one data that has a defined Name called "Titles" and located in Worksheet "TitlesExport".
I will be using this range in my worksheet Function V-LOOKUP.

For any reason, I am getting an error, something is wrong. I appreciate any help or input.

Please Login or Register  to view this content.

Thanks in advance for any help.

[HaHoBe]

Hi, Elomaldo,

any Range needs to be Set not just being equated to a range. And donīt use a VBA Keyword for both a Type and a Variable

Please try

Please Login or Register  to view this content.

Ciao,
Holger

[Elomaldo]

Hello Holger, Thanks foryour time, it is not working. For any reason still came out #Value.
No idea why is not working.

[Elomaldo]

Hi Holger,

Thanks for your input, I was thinking and Rearranging everything, now it works.

FYI and somebody else you can needed it.

Please Login or Register  to view this content.

Thanks for your time and all help

[Norie]

The likely reason for the #VALUE! is that something in the function's code has failed, for example the VlookUp.