+ Reply to Thread
Results 1 to 7 of 7

Array being missed....

  1. #1
    Registered User
    Join Date
    07-15-2010
    Location
    usa
    MS-Off Ver
    Excel 2003
    Posts
    51

    Angry Array being missed....

    I have two macro's that address arrays.

    macro 1
    Please Login or Register  to view this content.
    Followed by macro2

    Please Login or Register  to view this content.

    If macro 1 does not run, macro 2 runs just fine.
    If macro 1 does run, macro 2 does not run.

    It seems if macro 1 runs, macro 2 cant set up the array.
    Last edited by Slyone2; 08-09-2010 at 11:45 PM.

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Array being missed....

    What's the point of selecting multiple sheet in the first line of the first macro?

    More importantly, what are you trying to do?
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Registered User
    Join Date
    07-15-2010
    Location
    usa
    MS-Off Ver
    Excel 2003
    Posts
    51

    Re: Array being missed....

    The row count is 130+
    Mac1: Deletes One old row/line of data,
    Then adds an another line below.
    If not Range ($1:$200), shinks by one every time the macro runs. This methods keep range intact.

    Mac2: Setups sheets for new row.

  4. #4
    Registered User
    Join Date
    07-15-2010
    Location
    usa
    MS-Off Ver
    Excel 2003
    Posts
    51

    Re: Array being missed....

    12341234123
    Last edited by Slyone2; 08-10-2010 at 12:52 AM.

  5. #5
    Registered User
    Join Date
    07-15-2010
    Location
    usa
    MS-Off Ver
    Excel 2003
    Posts
    51

    Re: Array being missed....

    anyone have any ideas?

  6. #6
    Forum Expert snb's Avatar
    Join Date
    05-09-2010
    Location
    VBA
    MS-Off Ver
    Redhat
    Posts
    5,649

    Re: Array being missed....

    Please Login or Register  to view this content.

  7. #7
    Registered User
    Join Date
    07-15-2010
    Location
    usa
    MS-Off Ver
    Excel 2003
    Posts
    51

    Re: Array being missed....

    will this work on two different group arrays?

+ 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