Avatar of Matt Miller
Matt Miller
Flag for United States of America

asked on 

Trying to Copy sheets to a new workbook then hide sheets on original workbook

I'm trying to copy a group of sheets to a new workbook and then hide the initial sheets on the original workbook?'

      Sheets(Array("Read Me", "Sheet1", "Sheet2")). _
        Select

    Sheets(Array("Read Me", "Sheet1", "Sheet2")). _
        Copy
'Hide Readme

Open in new window


Thanks
VBAMicrosoft ExcelMicrosoft Office

Avatar of undefined
Last Comment
Roy Cox

8/22/2022 - Mon