| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Arrays and range references in VBA
I want to do something similar to this. Can it be done?
Sub gg() Dim t(40000) As Range, z as long z=0 For x = 1 To 40000 If CONDITION THEN z=z+1 Set t(z) = Range("A1")(x) end if Next t().Interior.ColorIndex = 39 End Sub Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Relative references in arrays | Excel Discussion (Misc queries) | |||
| How to rename references from range names to cell references | Excel Discussion (Misc queries) | |||
| Using arrays or range in IF function - HELP PLS | Excel Worksheet Functions | |||
| Dynamic Range and arrays | Excel Discussion (Misc queries) | |||
| Arrays: Subscript out of range | Excel Programming | |||
Threaded Mode
