Thread: Named Range
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
GMet GMet is offline
external usenet poster
 
Posts: 23
Default Named Range

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