Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Saving an array
G'day there again,
I've just found a smallish problem that I can't figure out. I'm trying to save an array of strings to a range. I've got the correct data loaded into the array, and I'm using this statement to save it: Worksheets("Data").Range("SavedShifts").Value = arrCtrl "SavedShifts" *IS* a named range on the "Data" sheet. However all I get is the data from arrCtrl(0) saved into each cell. A debug.print statement shows me that the data in arrCtrl is correct, but it's only saving a single value across the range. I'm sure it's something simple, but it escapes me completely. Any ideas, anyone? Thanks once more Ken McLennan Qld, Australia |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Saving an array
Ken,
Instead of ...... = arrCtrl use ...... = Application.Transpose(arrCtrl) HTH, Bernie MS Excel MVP "Ken McLennan" wrote in message .. . G'day there again, I've just found a smallish problem that I can't figure out. I'm trying to save an array of strings to a range. I've got the correct data loaded into the array, and I'm using this statement to save it: Worksheets("Data").Range("SavedShifts").Value = arrCtrl "SavedShifts" *IS* a named range on the "Data" sheet. However all I get is the data from arrCtrl(0) saved into each cell. A debug.print statement shows me that the data in arrCtrl is correct, but it's only saving a single value across the range. I'm sure it's something simple, but it escapes me completely. Any ideas, anyone? Thanks once more Ken McLennan Qld, Australia |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Saving an array
G'day there Bernie,
Instead of ..... = arrCtrl use ..... = Application.Transpose(arrCtrl) Thanks for that. I had to use Application.Worksheetfunctions.Transpose, but it worked like a charm. Thanks once again, Ken McLennan Qld, Australia |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automaticly saving formula's to values when saving | Excel Discussion (Misc queries) | |||
Prevent cell/array references from changing when altering/moving thecell/array | Excel Discussion (Misc queries) | |||
meaning of : IF(Switch; Average(array A, array B); array A) | Excel Worksheet Functions | |||
Saving a Workbook: Forcing User to Rename before Saving | Excel Programming | |||
variant array containing cel adresses convert to actual ranges-array | Excel Programming |