Hi all I can get the following sheet array by using the
macro recorder. Code: Sheets(Array("EPN SUMMARY", "Dashboard", "Ian Cameron", "Vladimir", "Ken Golding", _ "Andy Billings", "Stuart Weatherston", "Paul Symonds", "Peter Ball", "Ivan Key", _ "PM2", "PM3", "PM4", "PM5")).Select I need this line of code to be be more dynamic. The sheet names can change and can be ...