Selection of active cell and non-contiguous variable cells

[raptorius]

Lo,

I m new here and just found this great site.

My problem

I want to make a selection of non-contiguous cells
The selection varies daily
So m i m using a active cell for the selection proces

i want to select the activecell + the range of (the cell starting 2 cells next of the active cell) and (the 2 cells down starting from the new activecell)

to make it more cleary

if cell A3 is the active cell
I want to select A3 AND the range of C3:C5

no other cells should be selected

 

[TonyJollans]

Hi raptorius,

Here's one way of doing it ...

Union(ActiveCell, Range(ActiveCell.Offset(0, 2), ActiveCell.Offset(2, 2))).Select

Enjoy,
Tony

 

[raptorius]

using union i see
it works fine

thx tony