| 0 |
Subject: Excel Queston #2: Deletions
Posted by: TacoJohn
- [576191613] Sat, Aug 14, 2004, 05:17
Okay, final thing (I think) and then my own "Draft Dominator" of sorts will be complete.
I want to be able to delete a row and slide everything up and have the formulas reference the info that has slid up to that spot.
So a formula is referencing D1, when I delete what's in D1 I get "#REF" instead I want the formula to just use what has moved into D1.
Is there a way to do the formulas or a setting I click somewhere or what? |
| 1 | TacoJohn
ID: 576191613
Sat, Aug 14, 2004, 05:26
|
Okay, I've found the R1C1 setting (the term "absolute reference" flashed in mind, so I typed into help found my way over to R1C1).
Anyway, this looks right except for it's still giving me a slight problem.
Say I have a value in R1C1, and R2C2 references "R[-1]C[-1]". When I delete R1CI, that reference "R[-1]C[-1]" changes to "#REF"
What can I do?
|
| 2 | Cosmo's Cod Piece
ID: 144192417
Sun, Aug 15, 2004, 10:37
|
Try this...
Change "D1" in your formula to "$D$1"
The "$" symbol locks your formula into that particular cell so it'll reference what's in there.
|
|
|
|
Post a reply to this message: (But first, how about checking out this sponsor?)
|