Saw this question here:
Public Function NumSheets()
NumSheets = ThisWorkbook.Sheets.Count
End Function
Then, in a cell, type =NumSheets()
Sometimes it is a trivial answer.
Great job as usual. I'm sorry that I did not make myself clear. I have several workbooks that contain several sheets each and while I do have tabs at the bottom, I wanted to see a number perhaphs at the bottom representing how many sheets the workbook had upon opening it. If that's not possible, that's okay. I really appreciate the shortcut. It's going to come in very handy. ThanksThe simple answer is to create a UDF, which reads:
Public Function NumSheets()
NumSheets = ThisWorkbook.Sheets.Count
End Function
Then, in a cell, type =NumSheets()
Sometimes it is a trivial answer.
0 comments:
Post a Comment