Results 1 to 4 of 4

Thread: SOLVED excel vba - looping though all worksheets

  1. Jul 2nd, 2003, 04:54 PM #1
    LodBot
    LodBot is offline

    Thread Starter
    Member
    Join Date
    Jul 2003
    Location
    Los Angeles, CA
    Posts
    49

    SOLVED excel vba - looping though all worksheets

    I need to be able to loop through all the worksheets of a document w/ out knowing the names of the worksheets. Does anyone know how I could go about doing this?

    Thanks,
    Alex
    Last edited by LodBot; Jul 3rd, 2003 at 01:03 PM.
    Reply With Quote Reply With Quote
  2. Jul 3rd, 2003, 12:38 AM #2
    opus
    opus is offline
    I don't do your homework! opus's Avatar
    Join Date
    Jun 2000
    Location
    Good Old Europe
    Posts
    3,863
    You get the number of all Worksheets using:
    VB Code:
    1. ActiveWorkbook.Sheets.Count
    And you can call each of those Sheets using
    VB Code:
    1. ActiveWorkbook.Sheets(Number)
    You're welcome to rate this post!
    If your problem is solved, please use the Mark thread as resolved button

    Wait, I'm too old to hurry!
    Reply With Quote Reply With Quote
  3. Jul 3rd, 2003, 10:25 AM #3
    LodBot
    LodBot is offline

    Thread Starter
    Member
    Join Date
    Jul 2003
    Location
    Los Angeles, CA
    Posts
    49
    works great

    Thanks for the help
    Reply With Quote Reply With Quote
  4. Jul 3rd, 2003, 10:30 AM #4
    opus
    opus is offline
    I don't do your homework! opus's Avatar
    Join Date
    Jun 2000
    Location
    Good Old Europe
    Posts
    3,863
    You're welcome, but don't forget to put "solved" in the original topic.
    You're welcome to rate this post!
    If your problem is solved, please use the Mark thread as resolved button

    Wait, I'm too old to hurry!
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width