Excel VBA DO UNTIL LOOP to copy ranges into master worksheet - Microsoft Community

Hi Dawn, The following will copy by worksheet index. However, if the user rearranges the worksheets then you might get the sheets copied in the wrong order. I have included a test to ensure that "Master" is not copied but if you can be sure it is always s

answers.microsoft.com