Splitting Large Tables into Several Based on Row Number

Hi I was hoping somebody could help me 'split' or copy,paste ranges from a table in CAD. I'm dealing with very large schedule generated in Excel and then pasted as CAD entities in CAD. I've created a lisp that will apply formatting etc but I'd really like to split the table up automatically based on row heights. I can create a selection using (vlax-invoke-method obj 'setsubselection) but I don't know how to use this and copy or split or paste.

Any help would be much appreciated - I'm losing my mind

Cheers

Matt

Why do you physically want to split the table? I'm assuming you're on 2009 (as per your registration here). In which case your tables can be set to have a maximum height. It then simply places the rest into columns on the right, while repeating the headings (or not as set). When you've got the table selected, you'll note the grip-triangles. The one in the bottom middle governs this feature, if it's turned into the table, it's set to have a maximum height.

You can also accomplish this using the properties palette. Select the table, open PP (Ctrl+1), and scroll down to the bottom group (Table Breaks). Set Enabled to Yes, specify a specific break height as the maximum table height. The Spacing governs by how much the new set of columns will be offset to the right. The the Repeat top/bottom labels allow repetition of your headings / totals.