array

[internetisnice]

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]

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.

 

[JLGWhiz]

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]

thanks!

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.