I guess i'm blind or dumb... but I can't find the circular reference.
Now it gives a result of "0" with the circular reference warning, but when i press on the function button it seems to give me the result i want.... Any ideas?
excel.PNG
Any ideas?
Thanks
Post your workbook.
If you arehappy with the results, please add to the contributor's
reputation by clicking the reputation icon (star icon).
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved.
To undo, select Thread Tools-> Mark thread as Unsolved.
http://www.excelaris.co.uk
Circ ref's can be evil lil devils, and often are not where excel tells you they are (on the bottom left corner, it will give the errer cell ref).
I normally start by deleting that cell (or range of cells) and see if the error goes away. If not, make a note where it now says the error is , CTRL Z to undo, and try again on the new ref. Sometimes you can track it down this way, other times, I have had to delete entire sheets at a time to try and track it down (depending on the workbook complexity)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks