A constant array?

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_" <thief_@hotmail.com> wrote in message
news:eL$UNsgRFHA.1436@TK2MSFTNGP10.phx.gbl...
> 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" <jim.coneXXX@rcn.comXXX> wrote in message
news:%23QsFnOhRFHA.2788@TK2MSFTNGP09.phx.gbl...
> 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_" <thief_@hotmail.com> wrote in message
> news:eL$UNsgRFHA.1436@TK2MSFTNGP10.phx.gbl...
> > 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_" <thief_@hotmail.com> wrote in message
> news:eL$UNsgRFHA.1436@TK2MSFTNGP10.phx.gbl...
> > 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_