Named range using offsets
 

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

Named range using offsets
 

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

Named range using offsets
 

Thank you so much much appreciated
--
with kind regards

Spike


"Spike" wrote:

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