G Guest Oct 12, 2006 #1 I want to show how many sheets I have in a workbook using a formula. The number changes everyday. What do I use, or can I even do this?
I want to show how many sheets I have in a workbook using a formula. The number changes everyday. What do I use, or can I even do this?
G Guest Oct 12, 2006 #2 This user defined function will do it... Public Function WksCount() As Integer WksCount = Application.Worksheets.Count End Function HTH,
This user defined function will do it... Public Function WksCount() As Integer WksCount = Application.Worksheets.Count End Function HTH,
K Ken Johnson Oct 13, 2006 #3 Gary said: This user defined function will do it... Public Function WksCount() As Integer WksCount = Application.Worksheets.Count End Function HTH, Click to expand... If any of your sheets are not worksheets (eg chart sheets, xl4macro sheets) then you should use... Public Function ShtCount() As Integer ShtCount = Application.Sheets.Count End Function Ken Johnson
Gary said: This user defined function will do it... Public Function WksCount() As Integer WksCount = Application.Worksheets.Count End Function HTH, Click to expand... If any of your sheets are not worksheets (eg chart sheets, xl4macro sheets) then you should use... Public Function ShtCount() As Integer ShtCount = Application.Sheets.Count End Function Ken Johnson
