Hello:
Need VB Code for below:
I have a range of cell content to be clear (Value only) but no formula in those cell.
The range is populated in cell H106.
Example cell
if cell H106 = D5:E102 then clear the value value only in cell range D5:E102
if cell C106 = G5:H102 then clear the value value only in cell range G5:H102.
Let me Know if you have any questions.
Thanks.
Riz
.
Try this...
Please Login or Register to view this content.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
Hello:
Its clearing the formulas in the cell also.
I want to make sure NOT to erase the formula.
Let me Know if you have any questions.
Thanks.
Riz
Please Login or Register to view this content.
Hello:
It is still easing the formula for some reason.
Let me Know if you have any questions.
Thanks.
Riz
The last code should work (not clear formulas). I don't know what to tell you.
Hello AlphaGrog:
Please refer to attached sheet, i have made a sample with similar formula.
Your code is in the module.
Please have a look and Let me Know if you have any questions.
Thanks.
Riz
Hi rizmomin,
So you have a cell with a formula in it. Let's say it is something like in C1 the formula is =A1 + B1.
You want to have the value in C1 not show the answer but keep the formula. This isn't how Excel works. If you put a formula in a cell it shows the answer.
Perhaps you want to show a white font on a white background for those cells. You aren't really clearing them, you are simply displaying the answers in white.
(I don't recommend this white on white hack!)
You are asking for something that Excel doesn't do, and shouldn't do.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
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