MrExcel Publishing
Your One Stop for Excel Tips & Solutions

#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

Posted by Aladin Akyurek on August 31, 2001 8:15 AM

What kind of data do you have in H11:H350?
It sounds like this range keeps changing by the macro that you use (by deleting rows). Is that what happens?