LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #8   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4
Default Problems evaluating defined names in VBA

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
defined names xcel user[_2_] Excel Worksheet Functions 1 December 14th 07 05:43 PM
Defined names lesley1000 via OfficeKB.com Excel Worksheet Functions 3 December 10th 07 02:50 PM
Evaluating names range from two different workbooks. Barb Reinhardt Excel Programming 0 February 27th 07 04:36 PM
NAMES DEFINED F. Lawrence Kulchar Excel Discussion (Misc queries) 5 November 14th 06 07:54 AM
Defined Names rickv Excel Programming 4 August 6th 05 01:39 PM


All times are GMT +1. The time now is 04:26 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"