Don -
This does not work. The cells in the original range have formulas that
contain varying ranges. I just need to paste the same formulas with just
the range portion of the origainal formula increased by one row.

Your formula fills some cells and clears others that are supposed to
contain formulas. This should not occur because the new table is of the
same size. Remember the reference *in* the original formulas are not
sequential. They vary.I just need the same formulas copied to the new
range with the range part of the old formula increased by one row.
Something like: newcell.formula="='Same_SheetName_as_oldformula!' &
original_row_in_old_formula + 1 row.

Any help would be appreciated.

Thanks.
Jay Dean


*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!