Range(range("MFS5Days").offset(0,-5), Range("MFS5Days").Offset(0,-1)).select


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Spike" wrote in message
...
I will be very grateful for any help on the following which is fairly
basic
but i cannot get it to work.

I want to select a named range using offsets as below.

Range(("MFS5Days").offset(0,-5), Range("MFS5Days").Offset(0,-1)).select

The named range MFS5Days refers to cell G4
--
with kind regards

Spike