+ Reply to Thread
Results 1 to 5 of 5

Combine two macros

  1. #1
    Registered User
    Join Date
    08-02-2012
    Location
    Cambridge, UK
    MS-Off Ver
    Office 2010 (Excel)
    Posts
    50

    Combine two macros

    I have two seperate macros (one created today by some kind people here in the forum and one made earlier) that i wish to use in unison.

    they are:

    Please Login or Register  to view this content.
    and


    Please Login or Register  to view this content.
    I wish the first part to action first, splitting up tabs, and then when completed, run the second one.
    I have tried putting them in one sheet together but they dont work together.

    Can someone help me paste them together to work? Thanks,

    For your reference, this is the kind of sheet i will be using them with: modded all data.xlsx

  2. #2
    Forum Contributor
    Join Date
    04-14-2013
    Location
    Karachi, Sindh, Pakistan
    MS-Off Ver
    Excel 2010 - 2013
    Posts
    139

    Re: Combine two macros

    Plz give this a try

    Please Login or Register  to view this content.

    Thanks

  3. #3
    Registered User
    Join Date
    08-02-2012
    Location
    Cambridge, UK
    MS-Off Ver
    Office 2010 (Excel)
    Posts
    50

    Re: Combine two macros

    Hi Ariff, thanks for the prompt response. So where do i put this? At the bottom of the other two and hit run?

  4. #4
    Forum Expert
    Join Date
    07-15-2012
    Location
    Leghorn, Italy
    MS-Off Ver
    Excel 2010
    Posts
    3,431

    Re: Combine two macros

    Your attachment does not have Sales sheet, each code must be in modules, not in sheets, try
    Please Login or Register  to view this content.
    If solved remember to mark Thread as solved

  5. #5
    Registered User
    Join Date
    08-02-2012
    Location
    Cambridge, UK
    MS-Off Ver
    Office 2010 (Excel)
    Posts
    50

    Re: Combine two macros

    Yeh, that was my error. sorry. i have been amending the file to call the first tab as sales. My bad.

    and ariff, thanks - this worked like a dream!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How to combine 2 macros into one
    By Foxcan in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-16-2009, 04:46 PM
  2. How to combine 2 macros
    By Launchnet in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 03-14-2009, 09:09 PM
  3. Combine 2 Macros
    By al007 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-29-2005, 01:00 PM
  4. Combine 2 macros into 1 Please.
    By Steved in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-19-2005, 07:05 AM

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