| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
array
i have this code for setting an arayy from a range
Set r = Range(ActiveCell, ActiveCell.SpecialCells(xlLastCell)) t = r.Value this is fast for not using "for next" or "do while" but as i need only some parts of the range (for example columns A C F G) how can i do that? is it possible? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
array
You can either pick up all the cells in that range and ignore them when you
process stuff. Or you can build your array by looping through the cells in the order that you want. internetisnice wrote: i have this code for setting an arayy from a range Set r = Range(ActiveCell, ActiveCell.SpecialCells(xlLastCell)) t = r.Value this is fast for not using "for next" or "do while" but as i need only some parts of the range (for example columns A C F G) how can i do that? is it possible? -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
array
You can probably use the Union function.
Set CombRng = Application.Unition(Range("A:A"), Range("C:C") _ Range("F:F"), Range("G:G") Check it out in VBA Help. "internetisnice" wrote: i have this code for setting an arayy from a range Set r = Range(ActiveCell, ActiveCell.SpecialCells(xlLastCell)) t = r.Value this is fast for not using "for next" or "do while" but as i need only some parts of the range (for example columns A C F G) how can i do that? is it possible? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
array
thanks!
"JLGWhiz" ha scritto nel messaggio ... You can probably use the Union function. Set CombRng = Application.Unition(Range("A:A"), Range("C:C") _ Range("F:F"), Range("G:G") Check it out in VBA Help. "internetisnice" wrote: i have this code for setting an arayy from a range Set r = Range(ActiveCell, ActiveCell.SpecialCells(xlLastCell)) t = r.Value this is fast for not using "for next" or "do while" but as i need only some parts of the range (for example columns A C F G) how can i do that? is it possible? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Prevent cell/array references from changing when altering/moving thecell/array | Excel Discussion (Misc queries) | |||
| Redimming an array dynamically assigned from range (how to redim first dimension of a 2-D array? /or/ reverse the original array order) | Excel Programming | |||
| meaning of : IF(Switch; Average(array A, array B); array A) | Excel Worksheet Functions | |||
| Array problem: Key words-Variant Array, single-element, type mismatch error | Excel Programming | |||
| Array problem: Key words-Variant Array, single-element, type mismatch error | Excel Programming | |||
Hybrid Mode
