Trying to make a variable array out of my own defined "Type":

Type ACL
email As String
action As String
access1 As String
access2 As String
location As String
End Type

I want to do:

Dim thisACL(rowCount) As ACL

but Excel is forcing me to do:

Dim thisACL(100) As ACL

Any idea how I can get around this restriction?

Here's one way:

Dim thisACL() As ACL
ReDim thisACL(1 to rowCount)

--
Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/

* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *


"WyoCracker" wrote in message
...
Trying to make a variable array out of my own defined "Type":

Type ACL
email As String
action As String
access1 As String
access2 As String
location As String
End Type

I want to do:

Dim thisACL(rowCount) As ACL

but Excel is forcing me to do:

Dim thisACL(100) As ACL

Any idea how I can get around this restriction?