IrishCharm
05-28-2008, 05:00 AM
Hi,
I am looking for help in runnning a quick macro that counts the number of tabs in a workbook, without necessarily knowing the names of those tabs or their order.
For example workbook with tabs:
"Control"
"Sheet1"
"Sheet2"
"Sheet4"
would return 4 and
"Sheet4"
"Control"
"Sheet2"
"Sheet1"
would return 4.
Any help would be great
I am looking for help in runnning a quick macro that counts the number of tabs in a workbook, without necessarily knowing the names of those tabs or their order.
For example workbook with tabs:
"Control"
"Sheet1"
"Sheet2"
"Sheet4"
would return 4 and
"Sheet4"
"Control"
"Sheet2"
"Sheet1"
would return 4.
Any help would be great