Declaring the name of the variable from a cell value

obener

Board Regular
Joined
May 31, 2009
Messages
118
hi all,

i just wanted to know if there is a way of declaring a variable and setting the name of the variable from a cell value?

thanks
 

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"

JoeMo

MrExcel MVP
Joined
May 26, 2009
Messages
17,886
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
When you declare a variable you have to furnish a name for it. You can set the value of that variable equal to a cell's value. Why would you want to change the name of the variable?
 

mikerickson

MrExcel MVP
Joined
Jan 15, 2007
Messages
24,206
Short answer, No.
Longer answer, Names can be referenced by the contents of a cell, but that doesn't sound like what you are looking to do.
Are you looking to have a list of text values matched with a list of other values, if so, a VLookup array is probably the best way.

What are you trying to achieve?
 

obener

Board Regular
Joined
May 31, 2009
Messages
118
that's what i thought but i just wanted to confirm it. What i'm going to do is go through a list of exams and see which ones are completed as each exam has multiple parts in them but I may just use counter(x) where x can change for different ones.
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,163,699
Messages
5,833,206
Members
430,196
Latest member
rez5656

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top