I have tried using a Public declaration at the top of my module. But It's not passing the exact value from one sub to another. It passes some value(I guess this is the value which I got when I ran the code for the first time). Any thoughts on this? Thanks
Please share the code with us
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Its solved nowthere was no problem with global variable. Actually it was because of using Worksheet_Calculate method. it was getting its value from previous calculation, so the global variable was not the right one. I changed the code by asking it to calculate the cell before running the sub
Last edited by mahmud1280; 05-19-2015 at 10:58 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks