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

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.

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,109,081
Messages
5,526,735
Members
409,717
Latest member
Oscarsalone

This Week's Hot Topics

Top