Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Sum to active cell
I have a macro, where I am trying to do a sum from row 5 to the active cell.
How do I designate the range. Here is what I have; Activecell.formula="sum(range(cell(5,0),cell(activ ecell,0))", but it gives me a compile error. TIA Greg |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
how do i set up a single cell continual entry in excel to total f. | Excel Discussion (Misc queries) | |||
Display actual contents of cell | Excel Discussion (Misc queries) | |||
copy a cell value not its function | Excel Discussion (Misc queries) | |||
Highlight Active Cell | Excel Discussion (Misc queries) |