Tab Count

A

ala

without using macros can i have a list of my tab names or at least how
many tabs the workbook has
 
G

Gary''s Student

Sure:

Use an area in one of the tabs and manually type in the names of the sheets.
Say we use column A. In another cell (not in column A, enter:

=COUNTA(A:A)
 
J

Jarek Kujawa

yes, to a way
if by "tabs" you mean worksheets (not chart sheets)

let's presume yr "first" worksheet in Sheet1, and Sheet100 is the last
one, ale other woksheets placed between Sheet1 and Sheet100

if A1 cells are unused in each and every tab in yr workbook

select A1
select all your worksheets by right clicking on any of them and
"select all sheets"
insert 1 into A1

then (say) in B1 of Sheet1 insert the formula:

=SUM(Sheet1:Sheet100!A1)

the result will be the number of all worksheets (including hidden) in
the workbook

HIH
 
Top