ACtiveworkbook.Worksheets.Count

--
HTH

Bob Phillips

"Ankur" wrote in message
...
is there any command to count the total no of worksheets in a file