Is there a way to batch edit a bunch of #REF!'s resulted from some mistake I made apparently I can't go back a couple steps to undo. This happened in a formula inside a bunch of cells after removing the referenced cell. Thanks
Is there a way to batch edit a bunch of #REF!'s resulted from some mistake I made apparently I can't go back a couple steps to undo. This happened in a formula inside a bunch of cells after removing the referenced cell. Thanks
Excel 1.0.1 (16.0.14326.20140) (Android)
Excel 2010 14.04.4760.1000
It depends on the edit you want to make. What does the formula look like and what do you want to change it to? I assume you mean that the #REF appears directly in the formula, rather than showing only in the result in the cell.
Yes, it's in the formula rather than the original referenced cell, for all cells, the same cell I deleted, well, transplanted elsewhere. I just went back to my last saved point, but I'd still be curious how you'd grab all those refs and bulk replace them if you know. Thanks
Let's try this again: What does the formula look like and what do you want to change it to?
What is the formula?
What is the specific cell you want referenced?
juntoo perhaps you are not understanding? 6string is asking you to SHOW (here) your formula so he can see what it looks like.
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)
Bookmarks