A
alm09
Is there a way to count the number of tabs in a worksheet?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Dave Peterson
In code???
msgbox Activeworkbook.sheets.count
msgbox Activeworkbook.sheets.count
Is there a way to count the number of tabs in a worksheet?
M
Mike H
You could use this function. Al + F11 to open VB editor, right click this
workbook and insert module and paste this in.
Function sheetsinbook()
sheetsinbook = Worksheets.Count
End Function
this formula in a cell will return the number of worksheets.
=sheetsinbook()
Mike
workbook and insert module and paste this in.
Function sheetsinbook()
sheetsinbook = Worksheets.Count
End Function
this formula in a cell will return the number of worksheets.
=sheetsinbook()
Mike
A
alm09
I would rather use the formula but it is not working. I get a #NAME? error.
Is there an input (i.e. file name) in the parentheses or is to remain null?
Is there an input (i.e. file name) in the parentheses or is to remain null?
M
Mike H
if its giving a name error then you haven't put the function it calls in the
correct place. Put the function in a module in your workbook.
Mike
correct place. Put the function in a module in your workbook.
Mike