Hi All
I have a workbook with multiple worksheets. Some worksheets have charts based on other Data Worksheets.
I notice that ActiveWorkbook.Worksheets.Count does not include Chart worksheets.
Example: if total number to worksheets in my workbook is 15 (10 data and 5 charts), then ActiveWorkbook.Worksheets.Count gives 10.
How to count worksheets with charts
Thank you
I have a workbook with multiple worksheets. Some worksheets have charts based on other Data Worksheets.
I notice that ActiveWorkbook.Worksheets.Count does not include Chart worksheets.
Example: if total number to worksheets in my workbook is 15 (10 data and 5 charts), then ActiveWorkbook.Worksheets.Count gives 10.
How to count worksheets with charts
Thank you