Array of sheets
Posted by Bill Mahoney on January 24, 2002 8:08 AM
Hello, i have a workbook containing 30 or so sheets. I am trying to find a way in which i can enter all the sheets into an array so i can perform a loop to copy and paste certain info into certain cells. I know i can do this by adding all the sheet names in the code and assigning them to a position in the array. But i wasn't sure if each sheet couldn't be called by an index that already exists instead of the sheet name. Thanks for any help.
The Alcott Group