View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
WyoCracker WyoCracker is offline
external usenet poster
 
Posts: 1
Default User Defined Type Structure - want it to be variable not numeric literal

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?