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