Formula relative to a List in Excel 2003

[Guest]

I have a formula I am using that refernces a cell in the top row of a listobject. I would like to clear the listobject, then copy the formula back, but the reference is off by one row. Any ideas how to clear the rows in a listobject so as not to lose the reference (ListObject.ListRows.Delete() messes up the reference)? What is the difference between rng.formula, rng.formular1c1 and rng.formular1c1local ? To clear the rows I am currently clearing eaches range and then resizing the LisObject.

 

[Guest]

re:
"What is the difference between rng.formula,
rng.formular1c1 and rng.formular1c1local ?"

Help (F1) explains pretty well. Basically, formula
is like rng.formula = "=sum("$A$1:$A$3"),
rng.formulatR1C1 = "sum("R1C1:R3C1") - R=Row#, C=Column#,
and rng.formular1c1local translates R1C1 to your
version (regional) language (ie English vrsn to German).

-----Original Message-----
I have a formula I am using that refernces a cell in the

top row of a listobject. I would like to clear the
listobject, then copy the formula back, but the reference
is off by one row. Any ideas how to clear the rows in a
listobject so as not to lose the reference
(ListObject.ListRows.Delete() messes up the
reference)? What is the difference between rng.formula,
rng.formular1c1 and rng.formular1c1local ? To clear the
rows I am currently clearing eaches range and then
resizing the LisObject.