Excel 2000: Selecting multiple cells using ActiveCell.Offset

[Paddington1881]

Hi

Is there a way of using the ActiveCell.Offset to copy multiple, but not adjacent cells?

For example if my activecell was A1, I want to copy cell D1 and F1 using offset (but not copy E1).

The only code I can find is -

Range(ActiveCell.Offset(0, 3), ActiveCell.Offset(0, 5)).Select

But this also selects cell E1...

Any ideas much appreciated.

Thanks
Darren

 

[Richard Schollar]

You would need to pass the refs as a string as per:

Range(ActiveCell.Offset(0, 3).Address & "," &  ActiveCell.Offset(0, 5).Address).Select

or use Union:

Union(Activecell.Offset(,3),Activecell.Offset(,5))

 

[Paddington1881]

Thanks Richard - works great.