+ Reply to Thread
Results 1 to 3 of 3

Loop through visible sheet?

  1. #1
    Forum Contributor NewYears1978's Avatar
    Join Date
    03-15-2010
    Location
    Forney, TX
    MS-Off Ver
    Excel 2016
    Posts
    962

    Loop through visible sheet?

    I have done this a billion times but for some reason this code is only doing it on the activesheet..what is my tired brain missing? Oddly for however many sheets I have, it runs the code that many times on the same sheet.

    Please Login or Register  to view this content.

  2. #2
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    work: 2016 on Win10 (notebook), private: 2019 on Win10 (desktop), 2019 on Win11 (notebook)
    Posts
    8,197

    Re: Loop through visible sheet?

    Hi NewYears1978,

    you are missing to reference the sheet chosen:
    Please Login or Register  to view this content.
    Ciao,
    Holger
    Use Code-Tags for showing your code: [code] Your Code here [/code]
    Please mark your question Solved if there has been offered a solution that works fine for you

  3. #3
    Forum Contributor NewYears1978's Avatar
    Join Date
    03-15-2010
    Location
    Forney, TX
    MS-Off Ver
    Excel 2016
    Posts
    962

    Re: Loop through visible sheet?

    Oh Lord, haha I am so stupid. I had recorded that and forgot to add the ws. This is what happens when you work in Excel all day every day and it's late at night. Thank you so much

+ 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. Loop through visible cells only
    By zanac in forum Excel General
    Replies: 6
    Last Post: 01-29-2020, 05:02 PM
  2. Loop all visible sheet not selecting last sheet
    By Hood in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-10-2017, 03:56 PM
  3. [SOLVED] Have a loop macro loop for all visible worksheets
    By Graeme-Black in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 08-22-2014, 11:01 AM
  4. Loop for visible row only.
    By calvinle in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-19-2014, 11:03 AM
  5. Replies: 4
    Last Post: 01-06-2014, 02:14 AM
  6. Loop through if visible?
    By djblois1 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 09-01-2011, 05:48 PM
  7. [SOLVED] loop on visible cells only
    By Sliman in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-26-2006, 09:10 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