ExcelBanter - Named Range

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Named Range (https://www.excelbanter.com/excel-programming/310344-named-range.html)

GMet

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

Jorge Rodrigues

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

All times are GMT +1. The time now is 08:52 PM.