Thread: Copy Application.Union(c.Offset(0, 1), c.Offset(0, 2)... to a list onsame & another sheet
View Single Post
  #27   Report Post  
Posted to microsoft.public.excel.programming
Howard Howard is offline
external usenet poster
  
Posts: 536
Default Copy Application.Union(c.Offset(0, 1), c.Offset(0, 2)... to alist on same & another sheet

Okay, so I should do the naming using Define Name where I can select the sheet name from the Scope drop down.

Seems to me the default is *fully absolute* as the name always shows up in the name manager $A$1:$A$5...

I think I'm getting more or less what you are saying, just need to start trying to use it more often.

Howard



Reply With QuoteReply With Quote