HI CJ Im sorry if my question assumed the worst but I tend to think that everyone is as dumb as myself when it comes to waging syntactical war on badly behaved software. I did run a few test with Bob's .EntireRow but couldn't raise an error from it; what I did notice is that it Inserts a sheet row not a table row and although the effect on the table is the same it would disupt any stuff to the right of the the table. Bob I think there may well be a lot of sense in what you say about tables especially as they do not always behave as expected. How long would you estimate for MS to put them right?