PDA

View Full Version : Select multiple sheets now not working



paddysheeran
08-03-2016, 06:12 AM
Hi All,

today I've had a number of users report that a reporting tool is not working as sheets are not being selected before being copied to another workbook.

I've tried this small extract in a sample workbook and it no longer seems to function. has anyone had this problem and if so have a solution?

[CODE][Sheets("Sheet2").Select
Sheets("Sheet3").Select (False)/CODE]

thanks

Paddy

Paul_Hossler
08-03-2016, 07:10 AM
Doesn't work for me either, but another way I've always used




Sheets(Array("Sheet2", "Sheet3")).Select

paddysheeran
08-04-2016, 05:26 AM
Doesn't work for me either, but another way I've always used




Sheets(Array("Sheet2", "Sheet3")).Select


yes I've put that in place already for one of the workbooks but there are hundreds out that that have just stopped working. going to have to update them all.

just don't understand why it has been ok for years and now all of a sudden it doesn't work