I know I can get the value of a workbook-scoped Named Range from anywhere. Range("MyRange").Value
But, I have a Worksheet_Change where I have a need to get the value in that Named Range. It crashes.
I can get the value in the Immediate Window, however.
I solved it by explicitly referencing it Sheets("Runtime").Range("MyRange").Value
But why? It's a workbook-scoped Named Range!
Also tried making the Worksheet_Change procedure not a Private one. Same problem.
Thanks for any insights on this.