Excel VBA Question.

[KiwiGuy]

Hey All,

Does anyone know how to create/change a range in excel vba. I want to be able to select a range say Col1 and Col3 then change that range so it looks at Col1 and Col5, Col1 will always be the same in the range but the second column selected could be any column, im using this to create a graph on the fly.

Cheers

Ben

 

[ide]

to select the "A" and the "D" columns:
Range("A:A,D&quot.Select

the following example selects the "A" and the "D" columns, assig it to the myRange, sends the selection's address, then changes myRange to ("A1:A20,D120&quot and so on..

dim myRange as Range
Set myRange = Range("A:A,D&quot
myRange.Select
MsgBox Selection.Address
Set myRange = Range("A1:A20,D120&quot
myRange.Select
MsgBox Selection.Address