+ Reply to Thread
Results 1 to 3 of 3

Excel 2002 Macro multiple changes

  1. #1
    Registered User
    Join Date
    03-31-2009
    Location
    Chattanooga, TN
    MS-Off Ver
    Excel 2003
    Posts
    4

    Excel 2002 Macro multiple changes

    I am working on budget files for our new fiscal year. I need to update all of
    my macros from referencing budget 08-09 to referencing budget 09-10. The
    problem is, I have over 100 worksheets included within the macro to change to the new budget year, but I don't want to have to go into each macro and
    manually change 100 worksheet names. How can I update all the macros at the same time or can I?
    Thanks.

  2. #2
    Valued Forum Contributor mdbct's Avatar
    Join Date
    11-11-2005
    Location
    CT
    MS-Off Ver
    2003 & 2007
    Posts
    848

    Re: Excel 2002 Macro multiple changes

    Can you do a Find and Replace (ctrl+H)? I'm assuming it is one large macro by your statement of
    I have over 100 worksheets included within the macro

  3. #3
    Registered User
    Join Date
    03-31-2009
    Location
    Chattanooga, TN
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: Excel 2002 Macro multiple changes

    After I sent my question to the forum, I realized that I could do the find and replace. Well, duh. Sorry to bother.

+ 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