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