| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying a Variant Array to a worksheet
What is the short-hand method to copy a varaint array to a worksheet.
Given a variant array called vaData which is 10 rows x 5 columns Range("F20:I26").Value = vaData 'Would copy the data to F20:I26 How can this be written dynamically using Ubound(vaData) and UBound(vaData,2) in place of the cell range reference? -- Regards, John |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Moving a Variant to Array | Excel Programming | |||
| ReDim Object array as parameter of Variant array | Excel Programming | |||
| Coercing a variant into an array | Excel Programming | |||
| Variant Array | Excel Programming | |||
| variant array containing cel adresses convert to actual ranges-array | Excel Programming | |||
![John Keith[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
