+ Reply to Thread
Results 1 to 3 of 3

Sort of loop happening with calling macros

  1. #1
    Registered User
    Join Date
    05-08-2006
    Posts
    76

    Exclamation Sort of loop happening with calling macros

    Hi there,
    you marvelous guys provided me with this macro to call up one macro or another depending on the value in a cell. It will delete a column before running a comparison macro. It works well!.
    I have now tried to use this macro to run two other macros but I get myself into a bit of a loop because in this case I am using an "add/remove button" to call a macro to
    1.add columns if they arent there
    or
    2.delete columns if they are there

    The macro below will delete the columns then add them again!!!
    I can see why but not sure how to fix it..The macro deletes the columns with macro colcut... then aa4 no longer has "Prelim Dwg sent to AB" so it calls macro pastcol and puts them back in!

    Any help appreciated

    Simon



    Please Login or Register  to view this content.

  2. #2
    Forum Expert
    Join Date
    01-15-2007
    Location
    Brisbane, Australia
    MS-Off Ver
    2007
    Posts
    6,591
    Simon

    If you read the code, it actually reads
    Please Login or Register  to view this content.
    which is a complete command on its own.

    It then does the second line which is
    Please Login or Register  to view this content.
    Maybe what you want is

    Please Login or Register  to view this content.
    HTH

    rylo

  3. #3
    Registered User
    Join Date
    05-08-2006
    Posts
    76

    Problem solved

    Thanks Rylo, yuo're a machine!
    that's what I needed, it seems to work perfectly.

    This problem is solved.

    Cheers

    Simon

+ 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