I am using Excel 2000, and I am attempting to build, what I consider an array
using the Type declariation.
Public Type SIGDB
SigName As String * 12
SigType As String * 15
Conflict As Integer
Oppos As Integer
Para As Integer
OS As Integer
AspectIndexClr As Integer
AspectIndexStop As Integer
AspectClrName As String * 20
AspectStopName As String * 15
AppBlk As String * 8
Side As String * 2
Direction As String * 2
End Type
In a module I have:
For i = 1 To NumSig
ReDim Route(i) As SIGDB
Route(i).SigName = Cells(cRow, 1)
Route(i).SigType = Cells(cRow, 2)
next i
When I later attempt to access the data it's not there.
Any ideas?

Bob