| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Arrays to Fill a Range
Here is a type of code that I am using now. myX, myY and myZ are
filled 'by force' down to rows and is extremely slow. How to make a code to insert these values into an array and then transfer the contents of the array to the range? Code:
Sub Test()
i = 10
j = 10
For myX = -i To i
For myY = -j To j
myZ = i + j
ActiveCell.Value = myX
ActiveCell.Offset(0, 1).Value = myY
ActiveCell.Offset(0, 2).Value = myZ
Cells(ActiveCell.RoW + 1, 1).Select
Next myY
Next myX
End Sub
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using arrays or range in IF function - HELP PLS | Excel Worksheet Functions | |||
| Dynamic Range and arrays | Excel Discussion (Misc queries) | |||
| Dynamic Range and arrays | Excel Worksheet Functions | |||
| How To Fill 2D Arrays Easily | Excel Programming | |||
| Arrays: Subscript out of range | Excel Programming | |||
Threaded Mode
