how do you delete cells when they are connected with a formula

You are probably getting ###### in the cells because the numbers cannot fit
in the cells.

Try this:
Select all of the number cells
FormatCellsNumber tab
Category: Number
Decimal Places: 0
Click [OK]

If you still see ######, make the column width wider by doing this:
Click on the column heading
FormatColumnWidthAutofit Selection

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"Rere" wrote:

I'm sorry Ron, I don't get it!!! When I do that, it just puts #####in the
columns.

"Ron Coderre" wrote:

Let's back up a step or two.....

Put this formula in Cell A2, then copy it down as far as you need it.
=MAX($A$1:OFFSET(A2,-1,0))+1

Now you should be able to delete any row (except row 1) without creating
formula errors.

Does that fix the problem?

***********
Regards,
Ron

XL2002, WinXP-Pro


"Rere" wrote:

Sorry, Ron. I just re-read your post. Yes, this is where I'm putting it.

"Rere" wrote:

Well, I didn't personally put it there, but yes, that's where it is. I've
just been handed this to update today.

"Ron Coderre" wrote:

This formula:
=MAX($A$1:OFFSET(A73,-1,0))+1

should be in Cell A73. Is that where you put it?

***********
Regards,
Ron

XL2002, WinXP-Pro


"Rere" wrote:

Ok Ron, it's now telling me I have too few arguments.????This is the way I
did it: I'm deleting the row where Charlie's name is, so its: A73+1
=MAX($A$1:OFFSET(A73,-1,0))+1

Now, after I put in this info do I hit enter or what?

"Ron Coderre" wrote:

I think I understand what you're facing....

It seems like you want to use formulas to create a numerical
sequence(1,2,3...), and you do that by adding 1 to the cell above the formula
cell, right? The problem occurs when you delete the referenced cell's row.
Example:
A10: =+SUM(A9)+1
--iF row 9 is deleted...the formula returns an error.

Here are some alternatives to that approach:

A10: =OFFSET(A10,-1,0)+1
(ALWAYS adds 1 to the value of the cell directly above the formula cell)
or
A10: =MAX($A$1:OFFSET(A10,-1,0))+1
(Adds 1 to the previous max value above the formula cell...allows for blank
cells in the referenced range)

Am I on the right track here?
Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"Rere" wrote:

All I know how to do is enter info into a cell. This is a list of numbered
employees. Usually, I would just seleted the cell and delete, but I get
###error. The formula is =+sum (A73+1) Please help!!!