Move the code from the sheet in question to a new module, from which you can address any sheet in the workbook.
Move the code from the sheet in question to a new module, from which you can address any sheet in the workbook.
Graham Mayor - MS MVP (Word) 2002-2019
Visit my web site for more programming tips and ready made processes
http://www.gmayor.com