Ashes.cfg
10-02-2007, 07:17 AM
I have several excel workbooks whose worksheet names are customized. Plus all these workbooks have only one worksheet(the customized one).. All i want to do is activate that worksheet and if data is found create a new worksheet(Sheet2) and copy from customized worksheet to Sheet2.
Worksheets("Sheet1").Activate
This is not working since the name of the worksheet is not Sheet1. I wanna know if there is something like indexing which will activate the first workbook irrespective of its customized name!
Worksheets("Sheet1").Activate
This is not working since the name of the worksheet is not Sheet1. I wanna know if there is something like indexing which will activate the first workbook irrespective of its customized name!