Results 1 to 4 of 4

Better way to unhide/hide multiple sheets

Threaded View

  1. #1
    Forum Contributor
    Join Date
    11-25-2012
    Location
    Edmonton, Alberta
    MS-Off Ver
    2010
    Posts
    146

    Better way to unhide/hide multiple sheets

    I have a macro that I want to unhide 10 sheets print based on a formula (as I need to unhide them before I can print them I believe) then hide them again

    right now I have the following line 10 times to unhide the sheets.

    Sheets("Don't Unhide Motor Report (1)").Visible = True
    Sheets("Don't Unhide Motor Report (2)").Visible = True
    etc to 10

    is there a better way to write this? or am I stuck with these 10 lines at start and then 10 "hide" lines at the end?
    Last edited by JBeaucaire; 02-28-2013 at 09:21 PM. Reason: Added code tags, as per forum rules. Don't forget!

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1