Deleting Multiple Selected Sheets

**ajm036** · 03-26-2019, 04:55 PM

Hi - this code is part of a much larger code, but is essentially the very end. The code pastes values in for a bunch of graphs, then copies iterations of that sheet onto new sheets so that they can all be printed at the end. Then, I want to delete the sheets that the code creates. Everything works perfectly - Including printing ONLY the sheets it has selected, but for some reason activesheet.delete does not apply to all the sheets selected - it only deletes the last one. Does anyone know why / have any ideas?

Relevant part of code:

Please Login or Register  to view this content.

**mjr veverka** · 03-26-2019, 05:17 PM

It's not a code, it's some plain text that does not have the form of a code ...

**ajm036** · 03-26-2019, 05:27 PM

Hi - I didn't think it was relevant to post the entire code, everything works, except deleting multiple sheets at the end. Obviously there is stuff like Dim iCTR as integer, etc at the top, but I'm just having an issue with this one section - it just deletes the last sheet, not all of the ones it has selected. If I'm mistaken and the entire code has to be posted, please let me know.

**mjr veverka** · 03-26-2019, 05:48 PM

Ad 1. I meant that:

Please Login or Register  to view this content.

and

Please Login or Register  to view this content.

and etc.

Ad2. From fragments of matter(-s), shamans foretell ...

Ad 3. This snippet of code (in 'For...Next' loop):

Please Login or Register  to view this content.

does not select all sheets, only individually, then the next one.

**ajm036** · 03-26-2019, 05:52 PM

I don't know how to do the special code sections in the reply, but this part:

Please Login or Register  to view this content.

DOES select all the sheets - they are all highlighted if I exit the code. And the export to PDF works - all of the selected sheets are highlighted and export correctly, not the first three sheets in my workbook.

**jeffreybrown** · 03-26-2019, 05:56 PM

Administrative Note:

We would love to continue to help you with your query, but first, before we can proceed…
Please see Forum Rule #2 about the proper use of code tags and adjust accordingly...

**mjr veverka** · 03-26-2019, 06:26 PM

Ad 1.

Originally Posted by ajm036

DOES select all the sheets

You're right, with the 'replace:= false' argument, code expands the selection to other sheets.

Ad 2. Correct the tags, because moderator will block the answers.

**ajm036** · 03-27-2019, 09:05 AM

Hi - apologies, edited to comply with code tags.

**mjr veverka** · 03-27-2019, 02:41 PM

Try this scheme:

Please Login or Register  to view this content.

**ajm036** · 03-27-2019, 02:52 PM

That worked perfectly, thank you!!

Deleting Multiple Selected Sheets

LinkBack

Thread Tools

Rate This Thread

Display

Deleting Multiple Selected Sheets

Re: Deleting Multiple Selected Sheets

Re: Deleting Multiple Selected Sheets

Re: Deleting Multiple Selected Sheets

Re: Deleting Multiple Selected Sheets

Re: Deleting Multiple Selected Sheets

Re: Deleting Multiple Selected Sheets

Re: Deleting Multiple Selected Sheets

Re: Deleting Multiple Selected Sheets

Re: Deleting Multiple Selected Sheets

Thread Information

Users Browsing this Thread

Similar Threads

Deleting multiple sheets using vba code

Macro for deleting rows on multiple sheets

[SOLVED] adding or deleting in multiple sheets

[SOLVED] Deleting rows across multiple sheets?

Mirror row deleting on multiple sheets.

deleting column in multiple sheets

Deleting multiple sheets

Bookmarks

Bookmarks

Posting Permissions