Hello,
Could someone guide me as to how can I wrtie this code more efficiently without naming each name of the sheet.
Can I type in the code to copy sheets from SS to PNL, without mentioning all the sheets in between? Also if all the names of the sheets are extracted into one sheet named "HSheet" starting from A4 to A17 via formula , could the array be set to look into this range instead of naming every sheet? In both cases using the Array is a must for me.
Thanks and will appreciate.
Could someone guide me as to how can I wrtie this code more efficiently without naming each name of the sheet.
VBA Code:
Sheets(Array("SS", "PQ", "25", "CT", "50", " 100", " 1000", "65", "100 ", "LT ", "SMT", _
"CD", "PNL")).Copy
Can I type in the code to copy sheets from SS to PNL, without mentioning all the sheets in between? Also if all the names of the sheets are extracted into one sheet named "HSheet" starting from A4 to A17 via formula , could the array be set to look into this range instead of naming every sheet? In both cases using the Array is a must for me.
Thanks and will appreciate.