Hello experts
This code was shared by sandy666 which is working perfect. I just wanted to add one line to the code to get the value in the cells in place of the formula which is derived in multiple sheets. To replace the formula with value is easy in one sheet but in multiple sheets I need your expertise. Thank you in advance.
Please Login or Register to view this content.
Last edited by RAJESH SHAH; 04-27-2023 at 04:43 PM. Reason: #Solved by JohnnyL
"There is nothing called problem, it's just absence of an idea to find*solution."
?I have not failed. I?ve just found 10,000 ways that won?t work.?
?Thomas Edison
Add your code to remove the formulas right after your formula line.
I tried to add this line after the formula line but I am getting an error.
Please Login or Register to view this content.
I mean like it is still showing the formula ...
Try:
Please Login or Register to view this content.
It is showing value in just one sheet. The rest of the sheets are still showing formula.
Post your code as you have it now.
Got it right now. At first, placed your line in the end and it didn't work but after placing it below the formula line I got it replaced in all the sheets. 😜
Thank you JohnnyL.
Gee, I think post #2 mentioned something about that.
Yes. I thought nothing comes between IF and End IF, so I entered after End IF. But now I know that you can insert With and End With between IF and End IF or anything else too....
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks