Re: get name of sheets

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Cool - it is working.

I changed the code so that it operates from *** 2 to the second from
last. The last sheet is now the base for copying new sheets.

Is it possible to create a macro which will take the name in the cell
and copy the last *** to one with the cell name? That will allow me
to add envelope sheets as necessary.

Thanks again.

.

Quantcast