A constant array?

[Thief_]

Can this be made valid in VBA:

Const wsNot2Process = Array("Summary", "GraphResults", "*backup")

Or do I have to assign the array to a non-constant array variable?

 

[Jim Cone]

It looks like your choices are...

1. Const wsNot2Process1 As String = "Summary"
Const wsNot2Process2 As String = "GraphResults"
Const wsNot2Process3 As String = "*backup"

2. Dim wsNot2Process As Variant
wsNot2Process = Array("Summary", "GraphResults", "*backup")

Jim Cone
San Francisco, USA

 

[Thief_]

Thanks Jim.

--
|
+-- Thief_
|

It looks like your choices are...

1. Const wsNot2Process1 As String = "Summary"
Const wsNot2Process2 As String = "GraphResults"
Const wsNot2Process3 As String = "*backup"

2. Dim wsNot2Process As Variant
wsNot2Process = Array("Summary", "GraphResults", "*backup")

Jim Cone
San Francisco, USA

 

[keepITcool]

alternative
store the constant as a delimieted string,
create the array with split function

const x = "Summary;Graphresults;Backup"

....
msgbox split(x,";")(0)




--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


Jim Cone wrote :