Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
A macro for converting formulas to formula results only
I need a macro that will convert a cell's formula to reflect its
formula result only based on the following: Range is A10:C200 Only when formula's result 0 Execute upon closing the file Thanks for any help you can provide. Michael |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
A macro for converting formulas to formula results only
For Each cell In Range("A10:C200")
If cell.Value2 0 Then cell.Value2 = cell.Value2 End If Next cell -- HTH Bob "Michael Lanier" wrote in message ... I need a macro that will convert a cell's formula to reflect its formula result only based on the following: Range is A10:C200 Only when formula's result 0 Execute upon closing the file Thanks for any help you can provide. Michael |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
A macro for converting formulas to formula results only
Sub convertformulas()
Dim c As Range For Each c In Range("p3:p8").SpecialCells(xlCellTypeFormulas) If c 0 Then c.Value = c.Value Next c End Sub -- Don Guillett Microsoft MVP Excel SalesAid Software "Michael Lanier" wrote in message ... I need a macro that will convert a cell's formula to reflect its formula result only based on the following: Range is A10:C200 Only when formula's result 0 Execute upon closing the file Thanks for any help you can provide. Michael |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
A macro for converting formulas to formula results only
Bob and Don,
I did something wrong with Bob's so I failed to get it to work but Don's worked fine. Thank you both for your time. Michael |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
creating a formula on one sheet that uses results of formulas on o | Excel Worksheet Functions | |||
Converting Formula Results to Actual Data Values | Excel Discussion (Misc queries) | |||
converting results from formula to text in a new column | New Users to Excel | |||
Display results of formulas not the actual formula | Excel Discussion (Misc queries) | |||
converting formulas into values using a macro in visual basic edit | Excel Programming |