ExcelBanter - #Ref!

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - #Ref! (https://www.excelbanter.com/excel-discussion-misc-queries/259304-ref.html)

Rick

#Ref!

When deleting rows above my reference line, I get #Ref! in my referenceline.
How can I keep the proper reference in the reference line? Example:

Col A is a date field
Col B row 1 contains a Text "This is it." ,
row 2 contains =if(A2="",B1,"Why?"
row 3 contains =if(A3="",B2,"Because",,, and so on until you get to
the reference line which contains =(B10)... after I delete rows( 7,8,9 ) I
get #Ref! in row 10.

Fred Smith[_4_]

#Ref!

See your other post.
"Rick" wrote in message
...
When deleting rows above my reference line, I get #Ref! in my
referenceline.
How can I keep the proper reference in the reference line? Example:

Col A is a date field
Col B row 1 contains a Text "This is it." ,
row 2 contains =if(A2="",B1,"Why?"
row 3 contains =if(A3="",B2,"Because",,, and so on until you get to
the reference line which contains =(B10)... after I delete rows( 7,8,9 ) I
get #Ref! in row 10.

All times are GMT +1. The time now is 10:49 PM.