ActiveCell.Offset - how do I extend the selected range ?

[Gerald Higgins]

Hi, tried searching for this but not found it so far.

I am using "ActiveCell.Offset" to select a specific cell, based on the current week number.
That bit works.
I then want to extend the selection from a single cell, to a range 6 columns wide, 2 rows deep, where the active cell is at the top left.

So for example, in week 1, select cell A1 (this bit works fine) and then extend the selection to the range A1:F3.
And in week 2, select cell G1 (this bit also works fine) and then extend the selection to the range G1:L3.

How do I do this ?

Thanks in advance for any help !

 

[JackDanIce]

Try:

ActiveCell.Resize(2,6).Select

 

[Gerald Higgins]

Beautiful ! Thank you !

 

[JackDanIce]

You're welcome!