View Full Version : Solved: Remove Formula

07-20-2007, 07:35 PM
Dear Sir,


C1 displays 2
When cursor in in C1 Then Formula bar displays =A1+B1

I want to remove formula but value in C1 must remain.

Please help

07-20-2007, 09:41 PM
If you are working in the UI, just type a 2 into that cell :)

Again in the UI, to apply this over a range, use Copy/Paste Special.

To apply this to a range in code:

Range("C:C").Value = Range("C:C").Value

07-20-2007, 10:20 PM
If you are working in the UI, just type a 2 into that cell :)

What is UI?

I do not want to type again.
Please suggest some other solution

07-20-2007, 11:53 PM
UI is user interface.
Being in the UI means that you do things manually, by clicking and typing, instead of running a code.

By applying it over a range, Patrick meant the following

1. Select the cells with the formulas. E.g. select column C.
2. From menu, select Edit / Copy
3. From menu, select Edit / Paste Special
4. On the appearing form, select "Values"
5. Click OK



07-21-2007, 01:11 AM
Ok thanks for helping

Is it possible to hide formula from c1
I mean calculation must updated in c1 but the formula should not appear.
Or formula should not be edit.


07-21-2007, 01:16 AM
You can do this by applying worksheet protection:

1. Right-click on the formula cell and choose Format Cells. On the Protection tab make sure the Hidden box is checked. Hit OK.
2. Now go Tools>Protection>Protect Sheet and hit OK.

Users now won't be able to edit/see the formula (you may want to apply a password to the protection so they can't simply unprotect the sheet).