Hi forum,
I am getting a circular reference error in data that lies "beyond" the sheet data (see screenshot) Capture.jpg, how do I resolve this?
Thanks in advance!
/vonborge
Hi forum,
I am getting a circular reference error in data that lies "beyond" the sheet data (see screenshot) Capture.jpg, how do I resolve this?
Thanks in advance!
/vonborge
Impossible to say, from a screenshot
Please do not upload a picture of your file...rather, upload a sample of your workbook, showing what data you are working with, a few samples of your expected outcome is (manually entered is ok) and how you arrived at that. (exclude sensitive info). Pictures are pretty much impossible to edit, and no-one wants to re-type your data for you Also, not all members can upload picture files (Company firewalls and stuff)
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
Hi,
Bit confused. The error message in the screenshot you give is not for a Circular Reference, but for division by zero?
Regards
True, but the problem is still that the error is further out than Column N, and thus I can't reach it - or at least I don't know how to...
That column appears to be just hidden.
Several ways to unhide, including:
Open the Go To menu (F5)
Type e.g. S1 (or any cell reference in the S column) in the Reference: box
On the Home tab, go to Format→Hide&Unhide→Unhide Columns
Regards
Thanks XOR LX, that solved it! (was some redundant calculations in the hidden cells from the original author of the file)
Didn't think of the Go-to route, but now I know
You're welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks