+ Reply to Thread
Results 1 to 5 of 5

Ignore Hidden Worksheets with Current VBA

  1. #1
    Forum Contributor
    Join Date
    08-08-2019
    Location
    CO
    MS-Off Ver
    Office 365
    Posts
    106

    Ignore Hidden Worksheets with Current VBA

    Hello everyone.

    I had help writing the below code, so I am not quite sure where to add this in. I am looking to run the entire code below, but IGNORE any sheets that are hidden. Can someone please point me in the direction of where to apply this modification? Thanks in advance.

    Please Login or Register  to view this content.

  2. #2
    Forum Expert
    Join Date
    07-23-2018
    Location
    UK
    MS-Off Ver
    O365 32bit (Windows)
    Posts
    2,047

    Re: Ignore Hidden Worksheets with Current VBA

    Maybe an IF to assess the visibility.

    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    08-08-2019
    Location
    CO
    MS-Off Ver
    Office 365
    Posts
    106

    Re: Ignore Hidden Worksheets with Current VBA

    Thanks for the suggestion. I actually did try that, but when running the macro I get a compile error: Next without For

  4. #4
    Forum Contributor
    Join Date
    08-08-2019
    Location
    CO
    MS-Off Ver
    Office 365
    Posts
    106

    Re: Ignore Hidden Worksheets with Current VBA

    EDIT* ByteMarks - I did not see your added "End If". That worked. Thanks so much! My apologies for missing that detail.

  5. #5
    Forum Expert
    Join Date
    07-23-2018
    Location
    UK
    MS-Off Ver
    O365 32bit (Windows)
    Posts
    2,047

    Re: Ignore Hidden Worksheets with Current VBA

    Great. Thanks for the feedback.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] VBA for Ctrl+Home for all worksheets including hidden and Very hidden
    By Neilesh Kumar in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 04-17-2018, 08:28 AM
  2. Replies: 0
    Last Post: 04-13-2018, 01:18 PM
  3. Counta ignore hidden columns
    By JSmith1504 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-25-2014, 10:12 AM
  4. [SOLVED] VBA Macro - Alteration of current macro to ignore hidden cells :)
    By Defratos in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-14-2013, 07:45 AM
  5. Replies: 3
    Last Post: 08-08-2006, 08:10 AM
  6. [SOLVED] how to ignore hidden cells with a countif
    By Lee in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 07:05 AM
  7. [SOLVED] how to ignore hidden cells with a countif
    By Lee in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 10:05 PM

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