+ Reply to Thread
Results 1 to 5 of 5

Multiple Macros on on worksheet

  1. #1
    Registered User
    Join Date
    09-17-2012
    Location
    Tampa, Florida
    MS-Off Ver
    Excel 2003
    Posts
    3

    Multiple Macros on on worksheet

    Good afternoon all.
    I have four separate macros on one spreadsheet that each copy and insert a range of cells, moving the rows beneath the inserted cells down.

    The macro inserting the first range of cell works consistently and correctly, and can be used multiple times.

    The remaining three three don't insert consistently where they are directed. As I am not sure how many rows may have been added prior to the macro is run, I have named a reference cell and find that cell at the beginning of the macro and insert the copied cells one row up. This works for a while for each macro, but at some point, the cells begin to insert randomly when the macro is called.

    I am stumped. Any ideas will be greatly appreciated.

  2. #2
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Multiple Macros on on worksheet

    Can you post the macros?
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin

  3. #3
    Registered User
    Join Date
    09-17-2012
    Location
    Tampa, Florida
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: Multiple Macros on on worksheet

    First Macro
    Please Login or Register  to view this content.
    Second Macro

    Please Login or Register  to view this content.
    Third Macro

    Please Login or Register  to view this content.
    Last edited by Cutter; 09-18-2012 at 09:05 PM. Reason: Added code tags

  4. #4
    Registered User
    Join Date
    09-17-2012
    Location
    Tampa, Florida
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: Multiple Macros on on worksheet

    The fourth macro is the same as the third... and thanks for helping

  5. #5
    Forum Expert Cutter's Avatar
    Join Date
    05-24-2004
    Location
    Ontario,Canada
    MS-Off Ver
    Excel 2010
    Posts
    6,451

    Re: Multiple Macros on on worksheet

    @ themie

    Welcome to the forum.

    Please notice that code tags have been added to your post(s). The forum rules require them so please keep that in mind and add them yourself whenever showing code in any of your future posts. To see instructions for applying them, click on the Forum Rules button at the top of the page and read Rule #3.
    Thanks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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