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.
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.
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.
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
I think this code has been written by watersev. It would be easier for you if you to let him know.
Hi. Yes that is right. OK, I will contact him. Thanks
OK. It is solved. Nothing wrong with the macro. It was the input file not containing enough data to generate complete sheet.![]()
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks