| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can you make Range Equal All Values in an Array?
I currently fill a range with array values like this.
' store control values For i = 1 To UBound(ctrlArray) Sheets("Data Storage").Cells(i, lngColumn) = ctrlArray(i) Next i Is there a way to make this faster? I thought you could use this line below, but it doesn't seem to work. Sheets("Data Storage").Range(Cells(1, lngColumn), Cells(UBound(ctrlArray) + 1, lngColumn)) = ctrlArray -- Cheers, Ryan |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SUMPRODUCT or SUMIF if any values in a range equal any values in another range | Excel Worksheet Functions | |||
| Count occurances of equal values in two col. - array within SUMPRO | Excel Worksheet Functions | |||
| Make all variable values in a Array equal to 0 | Excel Programming | |||
| How do I make a range of cells equal to one cell | Excel Discussion (Misc queries) | |||
| There must be a way!!!--set cells' values equal to calculated values in another range | Excel Programming | |||
Threaded Mode
