User Defined Type Structure - want it to be variable not numeric literal

  • Thread starter Thread starter WyoCracker
  • Start date Start date
W

WyoCracker

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 *
 
Back
Top