initialize 2 dimensional array

[gdanalakshmi]

Dim ProcessNames(1 To 10, 1 To 10) As String

ProcessNames = {{"New Standard Churn","11"},{"Churn (No Voice)","11"}}


I am getting a syntax error??

I am not able to figure it out??

 

[Mile-O]

You assign them thus:

ProcessNames(1,1) = "New Standard Churn"
ProcessNames(2,1) = "Churn (No Voice)"
ProcessNames(1,2) = "11"
ProcessNames(2,2) = "11"

 

[gdanalakshmi]

If I am declaring one by one, then I have to write a line for each assignment. Is there not any one line assignment separated by comma's???

 

[WayneRyan]

gdanalakshmi,

From the Help files:

Dim varData As Variant
varData = Array("Ron Bendel", "4242 Maple Blvd", 38, _
Format("06-09-1952", "General Date"))

Wayne