Here I go with more questions and no answers.

What version of Excel?

What type of table?

How does tabbing over to the last column of your table create a new row?

Which extra rows do you want removed?

You state that "a new row is created and all is good"

Why remove newly created rows which are "good" rows?


Gord Dibben MS Excel MVP

On Sat, 8 Mar 2008 17:08:00 -0800, jatman
wrote:

afternoon,

i have a table in an excel sheet. when i tab over to the end of the table,
a new row is created and all is good.

is it possible to remove the extra rows that are generated using a macro -
keeping in mind that the amount of extra lines can always be different.

jat