#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2003
    Posts
    10
    Rep Power
    0

    How to get number of worksheets in a excel workbook


    Hi,
    Does anyone know how to get the total number of excel worksheets in a workbook?
    Thanks
  2. #2
  3. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2003
    Location
    Danbury,CT
    Posts
    14
    Rep Power
    0
    try

    wkbkobjectname.Worksheets.count

IMN logo majestic logo threadwatch logo seochat tools logo