Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Macro to change a formula to a value
Hi. Another variation of an earlier thread ( thank Bob P).
I have a formula in Col M (Rows 2 thru 2000) and Col G (Rows 2 thru 2000). I would like to change the formula in COL M to its value if the formula in Col G has value "True". Is this possible ? Thank you in advance. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Macro to change a formula to a value
Enter and run this small macro:
Sub demo() For i = 2 To 2000 If Cells(i, "G").Value = True Then Cells(i, "M").Value = Cells(i, "M").Value End If Next End Sub -- Gary's Student "carl" wrote: Hi. Another variation of an earlier thread ( thank Bob P). I have a formula in Col M (Rows 2 thru 2000) and Col G (Rows 2 thru 2000). I would like to change the formula in COL M to its value if the formula in Col G has value "True". Is this possible ? Thank you in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro To Change a Formula to A Value | Excel Worksheet Functions | |||
Reusing formula | Excel Discussion (Misc queries) | |||
Running of Worksheet Change Macro breaks undo functionality. | Excel Discussion (Misc queries) | |||
Closing File Error | Excel Discussion (Misc queries) | |||
Formula for current month minus one = Quarter number in a macro. | Excel Discussion (Misc queries) |