Hello all,
I am trying to create a module which I can call via a button click on one worksheet such that it hides columns on another worksheet. However, I am having trouble selecting the ranges on my "Results" worksheet. Here is what I have
I think My trouble lies in the Me.Range call when I am trying to hide columns, but I don't know what I should be using instead.
Please Login or Register to view this content.
Thanks in advance!
In VBA you do not need to select sheets/cells/ranges to act on them - simply reference them (make sure the reference is properly qualified).
This code uses the sheet code name and not the worksheet name (shown in the sheet tab). Change the sheet code name to whichever sheet is the Results sheet.
Please Login or Register to view this content.
Palmetto
Do you know . . . ?
You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks