Hi guys
Is there anyway to skip to the next sheet if the PAGE is EMPTY??
At the moment if the page is empty it crashes
Please Login or Register to view this content.
Hi guys
Is there anyway to skip to the next sheet if the PAGE is EMPTY??
At the moment if the page is empty it crashes
Please Login or Register to view this content.
Hi Exodus, many threads out there on this:
https://www.mrexcel.com/forum/excel-...blank-vba.html
https://www.ozgrid.com/forum/forum/h...sheet-is-empty
If I add in "If Sheet1.Range("a1").Cells.Value = False Then"
How do I make it go "Next X" without running the rest of the code for that current x
By a nested loop outside (as the parent) of the current block. I think you'll get more responses if you put a bit more detail and upload a worksheet.
You could go to the next X but you're going to run into problems later, you have:
I think it's possible you could run into a Chart, or other object in the Sheets collection and you may run into problems with loop counters not matching up and your procedure could run out of range.Please Login or Register to view this content.
https://www.safaribooksonline.com/li...3/ch04s03.html
How aboutPlease Login or Register to view this content.
Hi
Have posted a sample of the data
Pages a to f are not in use in this example
Only page 1 to 13
I believe my code crashes on page 7 (Which once it deletes the top 49 rows it blank)
Use Fluff13 variant, but with 'Rows', i.e. "If .Range("A1").CurrentRegion.Rows.Count > 1 Then"
or maybe this way without "If .Range("A1").CurrentRegion.Rows.Count > 0 Then"
Please Login or Register to view this content.
Last edited by mjr veverka; 04-29-2018 at 12:28 AM.
Change
toPlease Login or Register to view this content.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks