-
Declaring Constants
Hi,
I have a massive macro, that I am now looking at consolidating and improving. One way I have decided to do this is to declare some Public Constants, but I can't really work out how.
For example, one of the cells that I need to declare is D89, on the 'Form 6' sheet, which I want to be called InstType. So what would the code be to have to let me do this?
The value in the cell may change, but the location won't vary.
Any help greatly appreciated.
We're a Kingdom, and we're United!!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules