+ Reply to Thread
Results 1 to 5 of 5

Modify code to perform on multiple worksheets

  1. #1
    Forum Contributor
    Join Date
    01-05-2010
    Location
    New York
    MS-Off Ver
    Excel 2016
    Posts
    747

    Modify code to perform on multiple worksheets

    I have the following code that runs every 10 seconds on the worksheet "Sheet1" in my workbook. How can I change the code to perform the exact same procedure on "Sheet2" in addition to "Sheet1"?


    Please Login or Register  to view this content.

  2. #2
    Forum Expert Bob Phillips's Avatar
    Join Date
    09-03-2005
    Location
    Wessex
    MS-Off Ver
    Office 2003, 2010, 2013, 2016, 365
    Posts
    3,284

    Re: Modify code to perform on multiple worksheets

    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    01-05-2010
    Location
    New York
    MS-Off Ver
    Excel 2016
    Posts
    747

    Re: Modify code to perform on multiple worksheets

    That code does not work. Sheet1 and Sheet2 need to be specified because there are other worksheets in the workbook

  4. #4
    Forum Expert Bob Phillips's Avatar
    Join Date
    09-03-2005
    Location
    Wessex
    MS-Off Ver
    Office 2003, 2010, 2013, 2016, 365
    Posts
    3,284

    Re: Modify code to perform on multiple worksheets

    I don't understand what you are saying.

  5. #5
    Forum Contributor
    Join Date
    01-05-2010
    Location
    New York
    MS-Off Ver
    Excel 2016
    Posts
    747

    Re: Modify code to perform on multiple worksheets

    you changed the code to run on every worksheet. The code should only be run on Sheet1 and Sheet2

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1