Hi,

I am making a macro and I am having trouble getting it to select all of my tabs at the same time so I can simultaneously make changes to all of them. The problem is that I need to be able to add new tabs without editing the macro. I have a tab for each state, and if I add a new state, the macro will not select the new tab and I have to add the new tab name into the array of sheets that are being selected. Is there a way to select all sheets from say the 3rd tab until the one before a tab named "Reference"?