Thread: Named Range
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jorge Rodrigues Jorge Rodrigues is offline
external usenet poster
 
Posts: 29
Default Named Range

Perhaps:
MyValue = Range("Finish")
Jorge

"GMet" escreveu na mensagem
...
I have a range (H20) on sheet "Calc" named "Finish"
When I try to capture the value of "Finish" I get nothing - it's empty.

Myvalue=Finish gets nothing
Myvalue = sheets("Calc").Finish get an error

How can I capture the value in the named range "Finish"?

GMet