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?

--
|
+-- 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


"Thief_" wrote in message
...
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?
+-- Thief_

Thanks Jim.

--
|
+-- Thief_
|

"Jim Cone" wrote in message
...
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_" wrote in message
...
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?
+-- Thief_

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 :

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_" wrote in message
...
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? +-- Thief_