Basic (?) Questions about Variables

Thorben

New Member
Joined
Jul 29, 2010
Messages
12
1. Is there a function /method to return/display the name (not content) of a variable?

2. Is there a variable type, which can store contents until its contents it changed - meaning the contents can survive re-compliations /workbook closings? (Const is not a variable!)

Thank you very much!
 

Some videos you may like

Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"

bobsan42

Well-known Member
Joined
Jul 14, 2010
Messages
1,343
2. Is there a variable type, which can store contents until its contents it changed - meaning the contents can survive re-compliations /workbook closings? (Const is not a variable!)
option 1 - a cell/range in a worksheet (which can be hidden)
option 2 - Custom Workbook Property (i like this a bit more)
option 3 - registry value (it's not portable)
option 4 - can't think of one right now :biggrin:
 

Watch MrExcel Video

Forum statistics

Threads
1,108,979
Messages
5,526,026
Members
409,679
Latest member
smars

This Week's Hot Topics

Top