Archive of Mr Excel Message Board
Back to Dates in Excel archive index
Back to archive home
#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
Re: #REF in my formulas when I insert a new line.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?
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.