Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Paste VBA formula into cell
I have a VBA macro which determines various ranges of cells that need to be
analyzed and assigns the ranges to different values, such as wrkRng. The line below does partially what I need. It calculates correctly and puts the value I'm looking for in the specified cell. Range("B6").Select ActiveCell.FormulaR1C1 = Evaluate("=COUNTIF(" & wrkRng.Address & ",""1"")") The problem I have is the macro needs to be run I need to run the macro before all of the cells have been updated. What I need is for the code to put the actual formula in the cell so it is recalculated as the cells are updated later and not the value from when it is initially run. Since the ranges vary I can't just hard code the formula. But if wrkRng happened to be D8:I25 at the time the macro was run, I want have this formula entered into cell B6: =COUNTIF($D$8:$I$25, "1") |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Paste VBA formula into cell
You have a reply at your earlier post.
PJ wrote: I have a VBA macro which determines various ranges of cells that need to be analyzed and assigns the ranges to different values, such as wrkRng. The line below does partially what I need. It calculates correctly and puts the value I'm looking for in the specified cell. Range("B6").Select ActiveCell.FormulaR1C1 = Evaluate("=COUNTIF(" & wrkRng.Address & ",""1"")") The problem I have is the macro needs to be run I need to run the macro before all of the cells have been updated. What I need is for the code to put the actual formula in the cell so it is recalculated as the cells are updated later and not the value from when it is initially run. Since the ranges vary I can't just hard code the formula. But if wrkRng happened to be D8:I25 at the time the macro was run, I want have this formula entered into cell B6: =COUNTIF($D$8:$I$25, "1") -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Paste VBA formula in cell | Excel Programming | |||
Paste A Cell Formula Into A Cell With A Macro. | Excel Worksheet Functions | |||
formula won't paste from one cell to another with current cell inf | Excel Worksheet Functions | |||
How do I sum a formula and paste it in 7 cell increments? | Excel Discussion (Misc queries) | |||
Copy paste formula up to a cell using VBA | Excel Programming |