CJ, I'm reading that article you posted, with an idea of trying out tables and, who knows?, maybe even trying some VBA on a sample table to see whether I encounter the same problem you're having. But I just noticed something in the article that got me wondering: What are the chances that a) you have the auto-expansion option on, and b) if you turn it off, your VBA programs will work normally?
I'm talking about this from the article:
Quote:
4. Automatic expansion of table
If you type anything next to a table, Excel assumes you want to expand the table and automatically increases the table size to include your new entry. Of course you can undo this expansion too, or switch off this behavior entirely.
|
I haven't found yet how I could switch off the behavior, but that's one possibility.
[Later:]
Here it is:
Quote:
|
If you don’t want the table to automatically expand or automatically fill columns with formulas, you can turn off the option. Click the Microsoft Office Button, and then click Excel Options. Select the Proofing category, and click AutoCorrect Options. In the AutoCorrect dialog box...click the AutoFormat As You Type tab. Clear the Include New Rows And Columns In Table check box to prevent Excel from expanding the table, and clear the Fill Formulas In Tables To Create Calculated Columns check box to prevent Excel from filling entire columns with identical formulas.
|
Another idea: If the table is automatically expanded, I wonder whether the right way to insert a new row in the table is simply to have your program add a row
adjacent to it, not within the table's range but in the row just below.