Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Running Macro on all the spreadsheets in a workbook

  1. #1
    Guest

    Default

    Question:
    I have created macro for searching, and the macro can only search one spread at a time. So, I am wondering is it possible to make the macro search all the spreadsheets in a workbook at the same time?
    Please Help me
    Thank you in advance

  2. #2
    Guest

    Default

    Hello,

    I beleive it is quite easy, I will call your macro that searches the worksheet as MySearchMacroName.
    Just create a new macro as follows:


    Sub SearchAllSheets()
    For Each Worksheet In Worksheets
    Sheets(Worksheet.Name).Select
    Call MysearchMacroName
    Next Worksheet
    End Sub

    Pierre

  3. #3
    Guest

    Default

    Hello
    I copy the code and paste it in ThisWorkBook and change the name of the macro. However it doesn't work
    Did i do something wrong?
    Thanks

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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