Using a variable in a formula

L

ljgibbons

Hi,

I am trying to use a range variable in a formula for a cell.
The code i have currently is:

rct = Selection.CurrentRegion.Rows.Count + 3
Range("e" & rct + 1).Formula = "=sum("e5:e" & rct)"

The rows would vary depending on sheets used.
Is this possible?
 
Top