Referencing named range in VBA

Say I have a variable ("noDates") in worksheet (Workbooks("Book1").Sheets("sheet1")) which calculates to an integer. I want to use this value in my macro to perform other operations.

Can't figure out all the Dim, set, and all other statements to make it happen. It should be very simple, but I'm stuck.

All help will be greatly appreciated.

I changed your title from "Simple reference question" because it does not describe your question. Normally I would cite you for a rule violation but I found it easier to just change it and answer your question. But please take the time to review our rules. There aren't many, and they are all important. Rule #1 is Use Good Titles.

By "variable" do you mean "named range"? If so then your code can refer to

Sheets("sheet1").Range("noDates")

If you tell us more about your code I can give you more specific direction.

How is noDates defined in Name Manager? If noDates was created in Name Manager, it is either a named range or named formula, and my answer is still valid.

If you want you can do something like this:

Please Login or Register  to view this content.

Please attach a file illustrating the problem. See yellow banner at the top of the page.

The paper clip icon does not work for attachments. To attach a file:

1. Under the text box where you type your reply click the Go Advanced button.
2. On the next screen scroll down and under the Attachments section click the Manage Attachments link, which will show a pop-up window.
3. Click the Choose File button to select a file to attached.
4. Click the Upload button to upload the file.
5. Then click the Close This Window button. Your file is now attached to your post.

Try:

Please Login or Register  to view this content.

There is no code in this book so I don't know how you want to use it. Just use

[nodates]

Actually I have no idea why this is the only thing that works. I tried several other things that should work but this was the one that did.

It's a named formula that returns a simple data type, so the only way to access its value is essentially by evaluating its formula (which is what the [] notation does.