Sirs
Kindly provide me a suitable method or VBA code for selecting multiple worksheets / tabs in a workbook. This is for a data entry work. Details are below.
The workbook is containing around 12000 random sheets out of which only 1500 worksheets are to be selected and tab coloured and they are neither adjacent nor in a particular order (Also they are to be renamed and that I shall do manually) . But the name / list of sheets/tabs to be selected shall be mentioned in the first sheet in Column A. Those sheets are to be selected. Tab coloring also I shall do according to the required color. Only selection is required now.
Thanking you, yours faithfully
VENU
Kindly provide me a suitable method or VBA code for selecting multiple worksheets / tabs in a workbook. This is for a data entry work. Details are below.
The workbook is containing around 12000 random sheets out of which only 1500 worksheets are to be selected and tab coloured and they are neither adjacent nor in a particular order (Also they are to be renamed and that I shall do manually) . But the name / list of sheets/tabs to be selected shall be mentioned in the first sheet in Column A. Those sheets are to be selected. Tab coloring also I shall do according to the required color. Only selection is required now.
Thanking you, yours faithfully
VENU