| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula, not results showing
I have typed the following code and when executed the formula shows in the cell not the number. What do I do?
Public Sub FormulaTest_Click( Range("E2").Selec If Range("A1").Value = "Input" Then Range("F2").Formula = "C2 + C3 If Range("A1").Value = "% of Rev" Then Range("F2").Formula = "C2*.5 End Su Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Search formula showing results plus 100 characters | Excel Discussion (Misc queries) | |||
| IF formula only showing positive results | Excel Discussion (Misc queries) | |||
| Showing negative values for formula results in red | Excel Discussion (Misc queries) | |||
| Showing Cummulative Top5 results with an array-formula...? | Excel Worksheet Functions | |||
| showing multiple results to a formula | Excel Worksheet Functions | |||
Threaded Mode
