Need Help Changing a Working Macro - Array Issue?

[taylbren]

Hello,

Below is the code I am currently using and it working as intended. I have another macro importing "export" sheets. As of now there has always been 6 sheets imported so I coded it as follows with the segment in question in bold.

Please Login or Register  to view this content.

Now, there wont always be 6 sheets imported in. How can I re-write this to allow flexibility in how many "Export" sheets will be added to my file? The sheets will always be called Export then Export (#) for however many end up being imported in.



Thank you!

-Taylbren

[PCI]

See next code and complte it with your code

Please Login or Register  to view this content.

[taylbren]

Here's my full macro:

Please Login or Register  to view this content.

Where should I re set up the dim for sht? I feel like I may need to change this entire macro in order to make it look for any export sheet.

[PCI]

Here your code updated => NOT TESTED

Please Login or Register  to view this content.