Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
need macro: convert formula to value
I dont want to see formula at selection area , only values
need macro to do so. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
need macro: convert formula to value
Turn on the macro recorder
then select your cells, format = cells, go to the protection tab and click both locked and hidden then protect your worksheet Turn off the macro recorder. Look at the recorded code. -- Regards, Tom Ogilvy "moshe" wrote in message om... I dont want to see formula at selection area , only values need macro to do so. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
need macro: convert formula to value
Hi
just wondering why you need a macro for this, as copy then edit / paste special - values works well in most situations. -- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ....well i'm working on it anyway "moshe" wrote in message om... I dont want to see formula at selection area , only values need macro to do so. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
need macro: convert formula to value
If you actually want to replace the formula with values as JulieD describes
Sub ReplaceWithValues() selection.Copy selection.PasteSpecial xlValues End Sub -- Regards, Tom Ogilvy "JulieD" wrote in message ... Hi just wondering why you need a macro for this, as copy then edit / paste special - values works well in most situations. -- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ...well i'm working on it anyway "moshe" wrote in message om... I dont want to see formula at selection area , only values need macro to do so. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro - Insert Equal Sign to Convert String to Formula | Excel Discussion (Misc queries) | |||
MACRO: Convert Row Formula to Value | Excel Discussion (Misc queries) | |||
convert a formula into a macro | Excel Discussion (Misc queries) | |||
Convert Vlookup Formula to Macro | Excel Programming | |||
Using Macro to convert 240 to PRN | Excel Programming |