I have a couple of dynamic variables which an excel macro is trying to convert and failing. I guessing the tables are being dynamically generated and then the dynamic variable gets assigned.
I need to trace the workbook for their use to see how their values are assigned. Unfortunately it's like a 30+ sheet workbook with very large tables.
Is there a way to do this? Whenever I use the names manger and try to go to source cell all it says is "=TRUE"
in visual basic
select view local windows
then when you step through your macro you will see all your variables
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks