Extending Selection

P

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
 
B

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)
 
P

Philip

That works thanks Bob

Bob Phillips said:
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)
Click to expand...
 
B

Bob Phillips

My pleasure.

--

HTH

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