by Paul Kelly | | Vault Code
This code is the template code that you use when creating a Modal UserForm. This code was referenced in this Webinar. The code below is the code that is placed in the UserForm. Your UserForm must have a button called Ok and Cancel. Set the Cancel property of...
by Paul Kelly | | Vault Code
CurrentRegion is a powerful method for returning a rectangular range of data Description CurrentRegion returns a range of all the adjacent cells to the given range. In the screenshot below you can see the two current regions. I have added borders to make the...