+ Reply to Thread
Results 1 to 4 of 4

How to apply code to all sheets in an array

  1. #1
    Registered User
    Join Date
    04-05-2013
    Location
    Scottsdale, Arizona
    MS-Off Ver
    Excel 2007
    Posts
    15

    How to apply code to all sheets in an array

    I understand when working in Excel, I can select multiple sheets as a group and then apply changes to the first sheet and those same changes will be reflected in all sheets of the group. I would like some help in doing this same thing using VBA. I have attached a workbook that I hope you can use to help me understand the way to work with sheets in an array. If I enter the following code
    Please Login or Register  to view this content.
    I am able to select all the sheets. I want to insert rows at the same location across all the sheets. But if I use

    Please Login or Register  to view this content.
    The row is inserted on the January Sheet only. Please let me know how I need to change that code in order to apply that same insert of the row on all sheets that have been selected in the array.

    Extra Credit
    The info I am working with looks like a table but is not formatted as a table. I won't be able to go back and format it as a table and I need to make sure that the formulas and conditional formatting applied to each row are copied into the newly inserted row as well.

    Thanks for any insight you can provide
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: How to apply code to all sheets in an array

    Maybe:

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    04-05-2013
    Location
    Scottsdale, Arizona
    MS-Off Ver
    Excel 2007
    Posts
    15

    Re: How to apply code to all sheets in an array

    Thanks John. Nice and simple. Appreciate the guidance.

  4. #4
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: How to apply code to all sheets in an array

    You're welcome. Glad to help out and thanks for the feedback and the rep. Please comply with Forum Rule No. 9.

    Acknowledge the responses you receive, good or bad. If your problem is solved, please say so clearly, and mark your thread as Solved: Click Thread Tools above your first post, select "Mark your thread as Solved". Or click the Edit button on your first post in the thread, Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Dropdown option or Edit button will not appear -- ask a moderator to mark it.

+ 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