Is there a way to initialize an array the same way you can initialize a
Variant? If so, what is the syntax? I tried to dim an array and make it
equal to an array as below, but could not get it to work. Thanks.

Dim DescArray As Variant, TrackColArray As Variant, ReportColArray As Variant


DescArray = Array("Type", "Store", "Name", "FDO", "GO Weekend", "SS
Groom", _
"Grooming", "DDC", "Phone")
TrackColArray = Array(1, 3, 4, 5, 6, 7, 8, 9, 12)
ReportColArray = Array(1, 2, 4, 5, 6, 7, 8, 9, 10)