View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Spike Spike is offline
external usenet poster
 
Posts: 140
Default 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