Thread: Refer to 1 cell relative from named range
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default Refer to 1 cell relative from named range
myrange.Cells(1) is C1 so you offset from that cell to locate A1

Set myrange = Range("C1:F10")
myrange.Cells(1).Offset(0, -2).Select


Gord Dibben MS Excel MVP

On Tue, 13 May 2008 22:33:30 +0200, Bret Bernever
wrote:

I just want the code for a relative reference. Relative from the named
range. As I already pointed out the named range =
Set MyRange = Range("C1:F10")
How do I refer to A1?

Reply With QuoteReply With Quote