Loop through array of sheets every 30seconds until WB closed

**terratushi** · 05-25-2019, 09:01 AM

Hi,

I have a stats report which I am displaying on a large screen for tracking purposes. What I would like to do is for Excel to automatically cycle through the sheets, staying on one sheet for 30seconds before moving to the next. I have code which achieves this, however it only runs once. What I need to happen is for this process to continue repeatedly until the workbook is closed. Is this possible?

The current code I have is:

Please Login or Register  to view this content.

Thanks :D

**Pepe Le Mokko** · 05-25-2019, 09:03 AM

WB =Warner Brothers ?

**Fluff13** · 05-25-2019, 09:16 AM

How about

Please Login or Register  to view this content.

**terratushi** · 05-25-2019, 09:20 AM

Superstar, thanks :D

**Fluff13** · 05-25-2019, 09:34 AM

You're welcome & thanks for the feedback

Loop through array of sheets every 30seconds until WB closed

LinkBack

Thread Tools

Rate This Thread

Display

Loop through array of sheets every 30seconds until WB closed

Re: Loop through array of sheets every 30seconds until WB closed

Re: Loop through array of sheets every 30seconds until WB closed

Re: Loop through array of sheets every 30seconds until WB closed

Re: Loop through array of sheets every 30seconds until WB closed

Thread Information

Users Browsing this Thread

Similar Threads

change source data br loop each loop in array vba

[SOLVED] Store sheets into array via loop to copy to new book

need vba to copy sheets from closed workbook and paste into all closed wb's

Loop thru an array of sheets

Copying sheets from a closed workbook - Excel 2013 crashes Sheets.Add

Loop new messages containing a table, populate a dynamic array, paste array to Excel

Macro to loop through sheets and print them out using an array

Bookmarks

Bookmarks

Posting Permissions