Hi
I cannot seam to find the answer to how you will set for instance a range for all modules. For instance:
Public MyArray as Range
How do I then set MyArray to e.g. "A1" so i can use the specified range in all my modules and subs? Is it possible also for values?
Thank you in advance for your reply :-)!
damp
Put this in a module-
This will set the myarray to Cell A1 of Sheet1. This variable can now be used in other subs and modules.
Please Login or Register to view this content.
Happy to Help
How to upload excel workbooks at this forum - http://www.excelforum.com/the-water-...his-forum.html
"I don't get things easily, so please be precise and elaborate"
If someone's post has helped you, thank by clicking on "Add Reputation" below the post.
If your query is resolved please mark the thread as "Solved" from the "Thread Tools" above.
Sourabh
Rather than a public Variable, you could use a Public Function.
That way, the syntax for its use would be exactly the same, but it wouldn't loose its value if there is a run-time error or if an End command is executed.Please Login or Register to view this content.
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks