I want to create this line
Selection.Formula = "=sum(g10:g999)"
I have a string Myrange = "g10:G999"
How can I use Myrange in Selection.Formula?
Asked
Active
Viewed 13 times
0
Scott Craner
- 137,650
- 9
- 45
- 77
-
2`Selection.Formula = "=sum(" & Myrange & ")"`. – BigBen Feb 11 '22 at 19:22