Extending Selection

[Philip]

I'm sure this has been discussed many times before.
I'd like to extend a selection without quoting explicit cell references.
I've tried using the offset command but can only selcet a single cell.
Having previously slected a cell I'd like to extend the selection to the
three cells to the left without explicitly naming the cell coordinates?

I recall that ExtendSelection worked in Word but I'm not sure how to do the
same thing in Excel?

TIA

Phil

 

[Bob Phillips]

Activecell.Resize(1,3).Select

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Philip]

That works thanks Bob

Activecell.Resize(1,3).Select

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Bob Phillips]

My pleasure.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)