Range Selection by variable

[DreamerZ]

If your range selection is:

Range("S25,F2,H14").Select

The cells are selected individually like you've clicked on each one while holding the Control key. All 3 cells are looked at like Cell 1.

How can you do that with variables?

Range(cellrange1,cellrange2).Select

doesn't work. Each variable is an Address ($A$1) and is viewed by the Range as Cell 1, Cell 2 so it's like you've selected the first cell, hit Shift and then selected the second cell so it selects the series, not the individual cells.

Thoughts? Thx.


DreamerZ
simplesolutions@prodigy.net
[ignore]

http://www.geocities.com/simplesolutions@prodigy.net

[/ignore]

 

[SkipVought]

Hi,

Set rng1 = Cells(25, "S")
Set rng2 = Cells(2, 6)
Set rng3 = Cells(14, 8)
Set rng4 = Application.Union(rng1, rng2, rng3)
rng4.Select

Keep in mind that in MOST cases, you need not nor should not select/activate since that slows code processing faq707-4105 How Can I Make My Code Run Faster?



Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

Skip,

http://www.TheOfficeExperts.com

 

[DreamerZ]

Thanks Skip. I was just getting back here to say, "nevermind. I found the Union method."





DreamerZ
simplesolutions@prodigy.net
[ignore]

http://www.geocities.com/simplesolutions@prodigy.net

[/ignore]