+ Reply to Thread
Results 1 to 3 of 3

MACRO that created new tabs is broken

  1. #1
    Registered User
    Join Date
    07-07-2010
    Location
    Mass, USA
    MS-Off Ver
    Excel 2003
    Posts
    9

    MACRO that created new tabs is broken

    Someone on this site created a MACO for me. (see attached excel file). It works almost perfect except for when the tabs are done poputating some of the row headers are missing. If you take a look at the tab "Sheet 21" line 3 is missing the title SP21. This happens to tabs that have multiple rows. Can anyone help fix this error?

    Thanks!
    Attached Files Attached Files

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    48,357

    Re: MACRO that created new tabs is broken

    A very quick look indicates that it is rows where the Project Codes have two values in the same column.

    Given that the name of the module is FoxGuy, I'm guessing that might be the author. Perhaps best to try and contact him?

    Regards

    Edit from Moderator: I already mentioned this to FoxGuy, and he said he'd take a look at it when he gets the chance.
    Last edited by Paul; 09-09-2010 at 06:11 PM. Reason: Added comment

  3. #3
    Forum Expert
    Join Date
    03-31-2009
    Location
    Barstow, Ca
    MS-Off Ver
    Excel 2002 & 2007
    Posts
    2,164

    Re: MACRO that created new tabs is broken

    Hi lissa;

    Here's the corrected file.
    Attached Files Attached Files
    Foxguy

    Remember to mark your questions [Solved] and rate the answer(s)
    Forum Rules are Here

+ 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