How to get my named range to show its value (1 cell)

[dmcgov]

hi all

i have tried the following to no avail:

Please Login or Register  to view this content.

what am i doing wrong?

[YasserKhalil]

Hello
I have tested the three lines and all the three worked well
It will be better to upload sample of your workbook ..

[Pete_UK]

Use Name Manager to check the spelling of VendorNumMax.

Hope this helps.

Pete

[Zer0Cool]

All 3 seem to be correct. You havent told us how they are to no avail...Does the code give you an error? The code runs but the cell is empty or shows unexpected results? etc.

As mentioned check the spelling of the static parts of your code (sheet names and named range names). Also ensure the x variable is a data type that can store the value of the named range.

A sample file would greatly help. Explanation of what you get when you run the code and what you expect to get would help too.