Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |