Hi all,
I am pasting several formulas in a named range with multiple areas. How can I keep the values only once they have calculated? I don't want to use the copy/paste method as it is slower and I would need to do each area of the range separately. I have tried using below ".Value = .Value" method, unfortunately it returns "#NA" for some cells even though the formula returns values??
Or is there an even better method I'm not aware of?
Please Login or Register to view this content.
I would have to see the sheet to be sure, but the "#NA" is probably generated because of a link to the original source, or by a formula outside the specivied range that you are converting.
Any code provided by me should be tested on a copy or a mock up of your original data before applying it to the original. Some events in VBA cannot be reversed with the undo facility in Excel. If your original post is satisfied, please mark the thread as "Solved". To upload a file, see the banner at top of this page.
Just when I think I am smart, I learn something new!
The odd thing is, it works, if I split it up into two parts! However, since some of my ranges have more than 2 areas, I was trying to find a way to shorten the code...
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks