CJ, since no one else is answering this I'll take a whack at it, not because I know the answer but because I expect I can find out; I'm good at reading manuals. But I have to ask a silly question first: What do you mean by "table"? I mean, table rows are worksheet rows, aren't they?
I'm not challenging you with what I think is a mistake on your part; you aren't the only one who talks about "tables" as though they're something more than just a place on a worksheet where you've stored columns and rows of data. But it's past time I stopped and asked: If it's something more, then what is it, exactly? Up 'til now, I've been content to put data in a range on a worksheet, and if another worksheet looks up data there I call it a table. But there's nothing special in its definition. You seem to have something else in mind.
I don't doubt there is a way to do VBA statements to manipulate the data. But why wouldn't a simple row insert do?
Maybe I should see your workbook.
|