+ Reply to Thread
Results 1 to 6 of 6

VBA Code (colums to row, autofill) stop working in row 294 when new cable code appear

  1. #1
    Registered User
    Join Date
    10-26-2012
    Location
    Bergen, Norway
    MS-Off Ver
    Excel 2010
    Posts
    15

    VBA Code (colums to row, autofill) stop working in row 294 when new cable code appear

    This VBA Code written to convert sheet from colums to row, stop working in row 294 when new cable code appear in Row A294. Any Idea? Sombody? Example attached. Orginal, VBA code, and result.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    09-01-2012
    Location
    Norway
    MS-Off Ver
    Office 365
    Posts
    2,844

    Re: VBA Code (colums to row, autofill) stop working in row 294 when new cable code appear

    It didn't stop when I tried it. The new sheet fills down to row 1203.
    <----- If you were helped by my posts you can say "Thank you" by clicking the star symbol down to the left

    If the problem is solved, finish of the thread by clicking SOLVED under Thread Tools
    I don't wish to leave you with no answer, yet I sometimes miss posts. If you feel I forgot you, remind me with a PM or just bump the thread.

  3. #3
    Registered User
    Join Date
    10-26-2012
    Location
    Bergen, Norway
    MS-Off Ver
    Excel 2010
    Posts
    15

    Re: VBA Code (colums to row, autofill) stop working in row 294 when new cable code appear

    That is right, but the result for Wire Group (Column H) is 1 in from Row 294 to 1203 and that should not be the case.


    Regards

  4. #4
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: VBA Code (colums to row, autofill) stop working in row 294 when new cable code appear

    I think this code has been written by watersev. It would be easier for you if you to let him know.

  5. #5
    Registered User
    Join Date
    10-26-2012
    Location
    Bergen, Norway
    MS-Off Ver
    Excel 2010
    Posts
    15

    Re: VBA Code (colums to row, autofill) stop working in row 294 when new cable code appear

    Hi. Yes that is right. OK, I will contact him. Thanks

  6. #6
    Registered User
    Join Date
    10-26-2012
    Location
    Bergen, Norway
    MS-Off Ver
    Excel 2010
    Posts
    15

    Re: VBA Code (colums to row, autofill) stop working in row 294 when new cable code appear

    OK. It is solved. Nothing wrong with the macro. It was the input file not containing enough data to generate complete sheet.

+ 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