Redford Kenny
New Member
- Joined
- Feb 23, 2022
- Messages
- 3
- Office Version
- 365
- Platform
- Windows
- MacOS
Hello,
Trying to put a SUM formula a couple of rows below my array but I am having no luck.
Can you look at the code and advise please.
Many thanks,
Red
Trying to put a SUM formula a couple of rows below my array but I am having no luck.
Can you look at the code and advise please.
VBA Code:
Range("J17").End(xlDown).Offset(4, 0).Select
ActiveCell.Offset(-4, 0).Select
Dim x As Range
Set x = Range(Selection, Selection.End(xlUp)).Select
Range("J17").End(xlDown).Offset(4, 0).Select
ActiveCell.Formula = "=SUM(" & x.Address & ")"
Many thanks,
Red
Last edited by a moderator: