Sheet array issue

[Boydie]

Hi All

I'm trying to select a few sheets in a workbook using cell values as the sheet names.

If I'm in Sheet1 and had typed "Sheet2" in cell A1 and "Sheet3" in A2 what would be the code to select these worksheets given these cell values.

I'm trying to copy these sheets into a new workbook.

Any advice would be greatly appreciated.

Thanks

Boydie

 

[Norie]

Perhaps.

arrSheets = Range("A1:A2")

arrSheets = Application.Transpose(arrSheets)

Worksheets(arrSheets).Copy

 

[Boydie]

Awesome.

Thank you very much for your help.