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

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?
 
R

Rob Bovey

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 *
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

user-defined data type capabilities 2
Scripting Dictionary to hold User Defined Type 2
Loop through a User-Defined Type? 2
Reading values into an array of User Defined Types 7
User-defined type collection in class module 2
VBA code in one Module referencing Public Variables Declared inanother Module failing 5
user defined type not defined issue 2
User Defined Type in place of Enum 1

Top