Is there a way to count the number of tabs in a worksheet?

In code???

msgbox Activeworkbook.sheets.count



alm09 wrote:

Is there a way to count the number of tabs in a worksheet?

--

Dave Peterson

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



"alm09" wrote:

Is there a way to count the number of tabs in a worksheet?

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?


"Mike H" wrote:

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



"alm09" wrote:

Is there a way to count the number of tabs in a worksheet?

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.

You could use this function. Alt + F11 to open VB editor, right click this
workbook and insert module and paste this in.

Mike


"alm09" wrote:

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?


"Mike H" wrote:

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



"alm09" wrote:

Is there a way to count the number of tabs in a worksheet?