| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cant delete user defined default chart type | Charts and Charting in Excel | |||
| Excel Message "user defined type not defined" | Excel Discussion (Misc queries) | |||
| Setting up a Custom type, User-defined, Default Chart | Charts and Charting in Excel | |||
| "User-defined type not defined" message in Excel | Excel Discussion (Misc queries) | |||
| why is it saying sheetcnt is "variable not defined" how to do a global variable to share over multiple functions in vba for excel? | Excel Worksheet Functions | |||
Threaded Mode
