View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Bret Bernever Bret Bernever is offline
external usenet poster
 
Posts: 27
Default Refer to 1 cell relative from named range

In article ,
says...

Relative to what?

The named Range!

Any cell in Range("C1:F10")?

No, outside the Range

What would that mean? A

[snip]

Thought my question was clear. Reading all your questions....probably
not. Sorry for that!

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?