Macro skipping over tabs...Can't figure out why

[bjohnsonac]

This workbook contains multiple tabs with identical set up. Each tab has a different name. The macro is supposed to copy every tab that is not named "Summary". However, for some reason it is skipping over some of the tabs. I can't figure it out! Sample spreadsheet and code attached. Based on the number of tabs (16) and number of rows entered on each tab (6), a total of 96 rows should be copied to the summary sheet, but only 48 are being copied. The rhyme and/or reason behind the missed tabs is a mystery! Please help

Please Login or Register  to view this content.

[JBeaucaire]

Let's simplify a little.

1) UNMERGE the cells A1185:B1185.
2) Put TOTAL HOURS in B1185 and clear A1185 completely, make sure it stays empty.

Now we can look UP column A from the bottom and always find the last used row with no interference.

3) Here's a simpler version of your macro:

Please Login or Register  to view this content.

This version of the macro will work regardless of how many sheets you may add in the future.