Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Canīt Convert Formulas to Values with Deactivate event
Hi Excel Gurus. I really appreciate your help !
I have a sheet with many formulas. When I leave the sheet I want to convert them to values. Macro Recorder gives this: Range("D15:E16").Select Selection.Copy Range("D15").Select Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _:=False, Transpose:=False Range("D14").Select But when I apply this code to the Deactivate sheet event it gives an error (it seems it doesnīt accept the selection method in the above code). Can anybody help me??? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing sheets after the DeActivate Event. | Excel Discussion (Misc queries) | |||
convert formulas to values | Excel Worksheet Functions | |||
Easily convert all formulas in 3d spreadsheet to values? | Excel Worksheet Functions | |||
Convert Values to formulas | Excel Worksheet Functions | |||
Convert Formulas to Values and Preserve Formatting | Excel Discussion (Misc queries) |