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

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" wrote in message
news:AZlxc.712075$Ig.178694@pd7tw2no...
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

That works thanks Bob

"Bob Phillips" wrote in message
...
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" wrote in message
news:AZlxc.712075$Ig.178694@pd7tw2no...
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

My pleasure.

--

HTH

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

"Philip" wrote in message
news:qXnxc.710469$oR5.626250@pd7tw3no...
That works thanks Bob

"Bob Phillips" wrote in message
...
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" wrote in message
news:AZlxc.712075$Ig.178694@pd7tw2no...
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