One Shot Array

[jaybee3]

Hey again folks,

Having a bit of an issue with an array (MyResult). Each "line", as it were, has five "columns", formatted differently (got some doubles and some strings). When I write the array using:

.Range(.Cells(1, 1), .Cells(UBound(MyResult), UBound(MyCodes))).Value = MyResult

Some of the string elements are converted to numbers. For example: MyResult(6,4) is "0718875" and this appears as "718875" on the sheet.

Any ideas?

 

[Andrew Poulsom]

Have you tried formatting the cells appropriately before transferring your array?

 

[Sektor]

For 1-dimensional array:

.Cells(1, 1).Resize(UBound(MyResult)) = MyResult

For 2-dimensional array:

.Cells(1, 1).Resize(UBound(MyResult,1), UBound(MyResult, 2)) = MyResult

 

[jaybee3]

Have you tried formatting the cells appropriately before transferring your array?

Yes it works if I format the cells before writing. However previously when I looped through the array writing the results individually, I didn't need to format the cells.