Home |
Search |
Today's Posts |
#8
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
Thank's for the reply, both of you! Thank's for the info of the locals window. I will definately use that a lot for debugging in the future. Regarding using the longer statement and .refersto, it unfortunately doesn't work. I still think that there is some bug in evaluating the indirect statement (or that I am using it in the wrong way). For this project, I think I will stick with the lengthy way of going back and forth between the worksheet and VBA by using the function EvaluateName. The strange thing is that all the names work perfectly well in the worksheet, but not from VBA, so I guess I'll go with the hidden worksheet option in the future. I like being able to work easily with names and was really glad when I found a name manager add- in, but working with them in a sheet is even easier. Yet again, thank's for all the help. Regards, Anders |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
defined names | Excel Worksheet Functions | |||
Defined names | Excel Worksheet Functions | |||
Evaluating names range from two different workbooks. | Excel Programming | |||
NAMES DEFINED | Excel Discussion (Misc queries) | |||
Defined Names | Excel Programming |