LinkBack URL
About LinkBacks
Hi All,
I need help
What is the VBA Coding to select ALL sheets EXCEPT the first tab (titled "UPC") AND any hidden sheets.
I have a document that I am trying to do this in and can't figure it out.
Any help will be most appreciated
Hi All,
I need help
What is the VBA Coding to select ALL sheets EXCEPT the first tab (titled "UPC") AND any hidden sheets.
I have a document that I am trying to do this in and can't figure it out.
Any help will be most appreciated
The only reason I am hiding sheets is because I cannot figure out how to "omit" them from the selection array.
How about
Please Login or Register to view this content.
Hi Melissalee,
I think you can only select a single worksheet at a time. You can do 3D formulas though. Read:
https://support.office.com/en-us/art...2-787d0bc888b6
Did you know that there are a limited functions for 3D formulas?
If you supply a sample workbook it might be easer to understand your problem...
Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
This worked perfect!! Thanks!!!
Originally Posted by Fluff13
How aboutPlease Login or Register to view this content.
Glad to help & thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks