Dear Excel Ninjas,
I have the following loop Macro below however the image gets distorted after every loop.
What code can i add to this so that I can be able to speed up the loop transition.
Your assistance will be most highly appreciated
Please Login or Register to view this content.
Last edited by luxy007; 08-23-2017 at 10:58 AM.
The code doesn't make sense, it looks like you are just selecting a sheet, waiting, then selecting another sheet. What is the loop supposed to do? You have a Do & loop, what is the loop?
Hi Dave. Let me give you some background to the loop. I have a pc that is linked to a tv dedicated soley to flip between the various woeksheets at one minute intervals. Sales volume is shown in the sheets. These worksheets are linked to pivot tables hense the refresh command and the calculate prompts are used to make sure that the correct data is shown on the screen.Originally Posted by davesexcel
The problem i am facing is that the tables in the worksheet get dostorted when the sheet is about to change to the next sheet
What can i add to prevent this from happening ensuring a smooth transition between the sheets?
Ahh..so does it get distorted right away, or on the 2nd or 3rd loop?
You may have to supply a sample so somebody can work on it.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
,
Bookmarks