Custom Sort list Exceeded, macro has too many line continuations, please help

%3CLINGO-SUB%20id%3D%22lingo-sub-1601550%22%20slang%3D%22en-US%22%3ECustom%20Sort%20list%20Exceeded%2C%20macro%20has%20too%20many%20line%20continuations%2C%20please%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1601550%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20spreadsheet%20that%20creates%20a%20table%20and%20copies%20hidden%20forms%20to%20their%20respective%20items%20as%20individual%20tabs%2C%20there%20are%20sometimes%20support%20forms%20which%20have%20been%20labeled%20with%20a%20connecting%20A-D.%20I%20would%20like%20the%20Table%20of%20Contents%20to%20sort%20column%20A%20items%2010%2C10A%2C10B%2C10C%2C10D%2C20%2C20A%2C20B%2C20C%2C20D%2C30%20and%20so%20on.%20I%20have%20tried%20bring%20the%20list%20from%20the%20%22sorter%22%20tab%20in%20through%20options%20but%20got%20cut%20off%20around%20880A%20mark.%20I%20amended%20the%20SORT%20Macro%20but%20got%20a%20line%20continuation%20error.%20I%20am%20doing%20this%20sort%20for%2010-5550%20with%20possible%20A-D%20available%20for%20each.%20Any%20way%20to%20make%20this%20happen%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1601550%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20%26amp%3B%20VBA%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESorting%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

I have a spreadsheet that creates a table and copies hidden forms to their respective items as individual tabs, there are sometimes support forms which have been labeled with a connecting A-D. I would like the Table of Contents to sort column A items 10,10A,10B,10C,10D,20,20A,20B,20C,20D,30 and so on. I have tried bring the list from the "sorter" tab in through options but got cut off around 880A mark. I amended the SORT Macro but got a line continuation error. I am doing this sort for 10-5550 with possible A-D available for each. Any way to make this happen?

0 Replies