Formula not updating

[Mikal]

Hello,
I have a sheet that refers to another sheet with a formula,

=IF(StartHereSubCom!A8>"",StartHereSubCom!A8,"")

If I delete row 8 on the other sheet it does this.=

IF(StartHereSubCom!#REF!>"",StartHereSubCom!#REF!,"")

How do I make it continue to look at cell A8?

Any help would be appreciated
Mikal

 

[macattackpro]

Try clearing the contents of Row 8 instead of deleting it entirely.

 

[jtakw]

Hi,

macattackpro's suggestion would be the easiest way to go, but if you're trying to delete row 8 to evaluate row 9, then 10, 11, etc., you can invoke the Volatile function of INDIRECT and put the text A8 in any unused cell:

Book1
	A	B	C	D
1	A8			s
2
8	s
Sheet6

Cell Formulas
Range	Formula
D1	=IF(INDIRECT(A1)>"",INDIRECT(A1),"")