Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello,
Is there a way to make Constants as Arrays? Something like: Public Const Doc(1) As String = "Rules.DOC" Public Const Doc(2) As String = "Personal.DOC" Public Const Doc(3) As String = "Reporting.DOC" etc... Currently I'm using: Public Const Doc_01 As String = "Rules.DOC" Public Const Doc_02 As String = "Personal.DOC" Public Const Doc_03 As String = "Reporting.DOC" ....but that doesn't allow me to run through the documents in a loop, like a For-To-Next. Any suggentions? TIA, |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Wierd names defined as arrays of constants?!? | Excel Discussion (Misc queries) | |||
Wierd names defined as arrays of constants?!? | Excel Discussion (Misc queries) | |||
Trouble with arrays (transferring values between two arrays) | Excel Programming | |||
Working with ranges in arrays... or an introduction to arrays | Excel Programming | |||
Arrays - declaration, adding values to arrays and calculation | Excel Programming |