PDA

View Full Version : Solved: Remove Formula



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

A1=1
B1=1
C1="=A1+B1"

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

matthewspatrick
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

tqm1
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

JimmyTheHand
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

HTH

Jimmy

tqm1
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.

Thnaks

RichardSchollar
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).

Richard