#REF in my formulas when I insert a new line.
Posted by Deidre on August 31, 2001 1:39 AM
I've got a database which takes input from a form. Each time I press "Submit" a new row is inserted(not added)in the database, all duplicate names are removed and the list is resorted A->Z.(There is a macro to do this)
The problem is I must draw graphs to show the current state in the Database and I have constructed formulas to extract this data, but each time I submit a new name all my formulas return a #REF value.I have tried to make range in my formulas referenced by putting in the $ but they still change. I am not permitted to change the "Submit" macro.
An example of one of my formulas is : =COUNTIF(Concise_View!$H$11:$H$350,$E$3)
Any help would be greatly appreciated