Solved

Quickie !  How to refer to a Name in VBA

Posted on 2011-02-16
6
251 Views
Last Modified: 2012-05-11
Example: This is very easy ... if I explain it correctly!

I have a value "J" stored in cell A1. (This value will change!)
I then define a NAME so that cell A1 is named "Initial"

In VBA code I want to set strInitial =   the value in name "Initial"
See below.  

dim strInitial as string
    strInitial = ?????

What is the correct syntax so that strInitial will hold the value of "Initial"
0
Comment
Question by:Patrick O'Dea
6 Comments
 
LVL 50

Accepted Solution

by:
Ingeborg Hawighorst earned 333 total points
ID: 34911458
Hello,

Range.("initial")

cheers
0
 
LVL 50

Expert Comment

by:Ingeborg Hawighorst
ID: 34911467
Or, to complete your code lines

dim strInitial as string
    strInitial = Range.("Initial")
0
 
LVL 50

Assisted Solution

by:Ingeborg Hawighorst
Ingeborg Hawighorst earned 333 total points
ID: 34911483
Sorry, not quite awake yet. no dot!!

Dim strInitial As String
    strInitial = Range("Initial")
0
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
LVL 33

Assisted Solution

by:jppinto
jppinto earned 167 total points
ID: 34911508
0
 

Author Closing Comment

by:Patrick O'Dea
ID: 34911543
Thanks all.
I said it was a quickie!

I will check the links out jppinto
0
 
LVL 45

Expert Comment

by:patrickab
ID: 34911839
This is much simpler and will also work:

dim strInitial as string
strInitial = [Initial]

The [] square brackets just mean evaluate.

Patrick
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Over the years I have built up my own little library of code snippets that I refer to when programming or writing a script.  Many of these have come from the web or adaptations from snippets I find on the Web.  Periodically I add to them when I come…
Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

820 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question