How to always Reference Cell even if row is deleted?

[willow1985]

[h=2]I am using the below formula but always get a reference error when I delete row 14. I always want it to reference C14 even if the row is deleted. Any idea how to incorporate an absolute or index in this formula?

=EOMONTH(C14,0)

Thank you to anyone who can answer this![/h]

 

[Eric W]

Try:

=EOMONTH(INDIRECT("C14"),0)

 

[willow1985]

Thank you very much!!

 

[Eric W]

You're welcome!