B Bob Phillips Nov 17, 2003 #4 activeworkbook.worksheets.Count counts just the worksheets as opposed to all sheets, and activeworkbook.charts.Count counts the number of charts -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) Jos Vens said: Yes there is: ActiveWorkbook.Sheets.Count Regards, Jos Vens Click to expand...
activeworkbook.worksheets.Count counts just the worksheets as opposed to all sheets, and activeworkbook.charts.Count counts the number of charts -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) Jos Vens said: Yes there is: ActiveWorkbook.Sheets.Count Regards, Jos Vens Click to expand...