table on excel sheet
 

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

table on excel sheet
 

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

table on excel sheet
 

sorry, it Excel 2007 on Vista.

i inserted a table from the insert insert table bar from the top. i was
prompted for where my "data" was and i selected the rows and columns that are
approprite for the worksheet (B13:F17). when the user enters the data, from
the first row and tabs over, the next cell is selected. at the end of the
row (colum F,) when the user hits the tab, the next cell in the next row is
selected (from B17 to C13.)

At the end of the created table (F17,) when the user hits the tab a new row
is created because there could be more data tha needs to be entered. the
user finishes entering all the data, prints and emails the sheet. the
counter increases by 1 (indicates usage) and closes. i have written the
macro for everything for up to this point.

the problem is it saves the newly created rows if extra data was entered. i
only want it to save the change on the usage count, no newly created rows.

thank you,

jat






"Gord Dibben" wrote:

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

table on excel sheet
 

I don't yet have 2007 installed and am unfamiliar with the "Tables" that used to
be "Lists", I believe.

Will pass you to one of the 2007 users for an answer.


Gord

On Sun, 9 Mar 2008 09:45:01 -0700, jatman
wrote:

sorry, it Excel 2007 on Vista.

i inserted a table from the insert insert table bar from the top. i was
prompted for where my "data" was and i selected the rows and columns that are
approprite for the worksheet (B13:F17). when the user enters the data, from
the first row and tabs over, the next cell is selected. at the end of the
row (colum F,) when the user hits the tab, the next cell in the next row is
selected (from B17 to C13.)

At the end of the created table (F17,) when the user hits the tab a new row
is created because there could be more data tha needs to be entered. the
user finishes entering all the data, prints and emails the sheet. the
counter increases by 1 (indicates usage) and closes. i have written the
macro for everything for up to this point.

the problem is it saves the newly created rows if extra data was entered. i
only want it to save the change on the usage count, no newly created rows.

thank you,

jat






"Gord Dibben" wrote:

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