Excel #REF in my formulas when I insert a new line.

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

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?

Aladin

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.

Archive of Mr Excel Message Board

#REF in my formulas when I insert a new line.

Re: #REF in my formulas when I insert a new line.