A
Al
Hey all
I have 2 arrays called arr1 and arr2 (string arrays)
arr1 contains the values 1, 2, 3
arr2 contains the values a, b, c
I have a third array, namesarr (also String), which contains the names
of the first 2 arrays
I am trying to have the following output on my excell sheet
arr1
1
2
3
arr2
a
b
c
Here is the code I am using:
For S = 0 To UBound(namesarr)
ActiveCell.Value = namesarr(S)
For Each element In Array(namesarr(S))
ActiveCell.Offset(1, 0).Select
ActiveCell.Value = element
Next element
Next S
here is what I get:
arr1
arr2
The contents of each of my arrays don't get printed. I am sure that I
am referencing them incorrectly, but I can't figure it out. any help
appreciated. Thanks
Al
I have 2 arrays called arr1 and arr2 (string arrays)
arr1 contains the values 1, 2, 3
arr2 contains the values a, b, c
I have a third array, namesarr (also String), which contains the names
of the first 2 arrays
I am trying to have the following output on my excell sheet
arr1
1
2
3
arr2
a
b
c
Here is the code I am using:
For S = 0 To UBound(namesarr)
ActiveCell.Value = namesarr(S)
For Each element In Array(namesarr(S))
ActiveCell.Offset(1, 0).Select
ActiveCell.Value = element
Next element
Next S
here is what I get:
arr1
arr2
The contents of each of my arrays don't get printed. I am sure that I
am referencing them incorrectly, but I can't figure it out. any help
appreciated. Thanks
Al