Thread: How to get evaluated value of worksheet names that do not refer to worksheet ranges?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dick Watson Dick Watson is offline
external usenet poster
  
Posts: 18
Default How to get evaluated value of worksheet names that do not refer to worksheet ranges?
Brain Damage.

Me.Evaluate ("NamedWhatever")

"Dick Watson" wrote in
message ...
I've also tried Application.Evaluate "=RowsToTest" but this gets into all
kinds of ugly issues of the context in which the evaluation is done since
these are all scoped to specific sheets and multiple workbooks may be open
when this needs to be evaluated.

Is there a workaround to get the evaluated value of these names that
aren't cell ranges?

Reply With QuoteReply With Quote