Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

variable naming

Status
Not open for further replies.
Luis939

Luis939

MIS
Feb 28, 2003
453
US
hey,
i basically would like to know if there is any mechanism i can use to create variables automatically,
so if i have
myvariable1 = somevalue

it would be really beneficial if i can loop back to it and change the name of that variable to something like myvariable2 so that I can keep them separate,

thanks!!!
 
Sort by date Sort by votes
If you were writing in assembler code you could, but not in VBA.

The closest that you might come is using an array with REDIM Preserve or creating or adding to a collection.

:)

Skip,
Skip@TheOfficeExperts.com
 
Upvote 0 Downvote
Is it possible to have an array whos elements are all collections? and if so what would be the syntax? thanks!
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

arvarr
  • Locked
  • Question
Variable in Pivot Table 1
Replies
4
Views
261
arvarr
arvarr
remeng
  • Locked
  • Question
Capture active macro name as a variable 1
Replies
16
Views
431
Andrzejek
Andrzejek
MattGreer
  • Locked
  • Question
Using A Boolean in a Calc, and setting a variable = "0" 3
Replies
6
Views
210
SkipVought
S
telephoto
  • Locked
  • Question
Pause vba and select cell as value for variable 1
Replies
8
Views
256
telephoto
telephoto
MattGreer
  • Locked
  • Question
Name a Range of Cells - Number of Cells is Variable 1
Replies
16
Views
287
SkipVought
S

Part and Inventory Search

Sponsor

Back
Top