Named range using offsets

[Spike]

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

[Bob Phillips]

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" <Spike@discussions.microsoft.com> wrote in message
news:7DBB400C-BE0C-4BD7-9DC3-2BC8AAAF1353@microsoft.com...
> 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

[Spike]

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