| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formual Issue
Hi,
Simple formula to insert a SUM. Range("G22").Select Selection.End(xlDown).Select ActiveCell.Offset(2, 0).Select ActiveCell.FormulaR1C1 = "=SUM(G5:R[-2]C)" But it returns in Excel......=SUM('G5':G124) which doesn't work. Any idea? Thanks John |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date formual issue | Excel Worksheet Functions | |||
| 8000 formual issue | Excel Discussion (Misc queries) | |||
| Formual | Excel Worksheet Functions | |||
| WHAT DOES FORMUAL =C8+ 15 DO | Excel Discussion (Misc queries) | |||
| what is mean by ^ in formual | Excel Programming | |||
Threaded Mode
