|Subject:||How do I add a new blank record (row)|
|Posted by:||jayC (te…@rcn.com)|
|Date:||Thu, 10 Jul 2008|
I have a table that consists of one row for each record. Each row contains
columns for inputing data and columns containing formulas.
I am trying to create a macro that inserts a new row (record) ABOVE the last
row (record) so that the newest rows are at the top of the table.
Would like the new record created by the macro to be blank except for the
cells containing formulas.
I am easily able to create many records below or above the current record.
However, I do not wish to have many blank records above the latest record -
only one blank record at a time when I press a button.
My unsatisfactory solution to this problem* created another issue: A row
that contains the totals for each column keeps changing the row numbers
every time another row is inserted at the top of the table in row 3. When
creating a new number 3 row by insertion, the sum changes from
$C$3...$C$1000 to $C$4....$C$1001. If another row is inserted at number 3 it
changes to $C$5....$C$1002 and so on.
It does this even when an absolute sign($) is used in front of the cell
*My solution is to copy a row containing formulas but no data way down at
the bottom of the table in row 950 and inserting it at the top of the table.