Good Morning
I want to do something similar to the usual =sum(a1:b1) command but i keep getting #name returned.
Dim Topcel, Botcel as range
set topcel = activecell
set botcel =activecell.offset(5,0)
activecell.offset(6,0).select
activecell.formulaR1C1 = "=sum(topcel,botcel)"
Not too sure where i am going wrong
I want to do something similar to the usual =sum(a1:b1) command but i keep getting #name returned.
Dim Topcel, Botcel as range
set topcel = activecell
set botcel =activecell.offset(5,0)
activecell.offset(6,0).select
activecell.formulaR1C1 = "=sum(topcel,botcel)"
Not too sure where i am going wrong