| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Need to re-initialize cell with original formula
During an initialization process, I need to reset some cells to their
original formula(s). I tried the following w/o success. The cell contents show as text afterwards rather than formulas. Help. Jim ' Reset Session formulas to Full Night Dim SessionCompareE3 As String Dim SessionCompareF3 As String SessionCompareE3 = "=COUNTIF(D8:D25000,"" ""&B1)" Range("$E$3").Select ActiveCell.FormulaR1C1 = SessionCompareE3 SessionCompareF3 = "=COUNTIF(D8:D25000,"" < ""&C2)" Range("$F$3").Select ActiveCell.FormulaR1C1 = SessionCompareF3 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copying a formula from original cell to mutilpe cells? | Excel Discussion (Misc queries) | |||
| Copy rows but need to refer to same cell in original formula | Excel Worksheet Functions | |||
| formula copies value from original cell only | Excel Worksheet Functions | |||
| Userform Initialize & combo box values | Excel Discussion (Misc queries) | |||
| copied formula has correct cell reference, but result of original | Excel Worksheet Functions | |||
Threaded Mode
