kimbe1jm
asked on
VBA Script to Sum from Active Cell to Top of Column
How would I substitute a full column rather than a static range in a summation formula for a cell?
similar to this which selects up to the top of the active column
Range(Selection, Selection.End(xlUp)).Selec t
but use it in the formula below so as not to choose a static range for the sum?
ActiveCell.FormulaR1C1 = "=(SUM(R[-8]C:R[-1]C)/100) "
similar to this which selects up to the top of the active column
Range(Selection, Selection.End(xlUp)).Selec
but use it in the formula below so as not to choose a static range for the sum?
ActiveCell.FormulaR1C1 = "=(SUM(R[-8]C:R[-1]C)/100)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.