having issue with the below coding I'm putting in for a VBA macro.
Simply trying to sum 2 cells
ActiveCell.Offset(0, 4).Value = SUM(ActiveCell.Offset(-2, 4).Value):(ActiveCell.Offset(-1, 4).Value)
Asked
Active
Viewed 2,800 times
0
nightcrawler23
- 2,056
- 1
- 14
- 22
javascript apprentice
- 23
- 1
- 5
1 Answers
0
Your way of adding is not the best way but just to answer your question, the below code should work
ActiveCell.Offset(0, 4).Value = WorksheetFunction.Sum(Range(ActiveCell.Offset(-2, 4).Address & ":" & ActiveCell.Offset(-1, 4).Address))
nightcrawler23
- 2,056
- 1
- 14
- 22
-
why is this not the best way ? – javascript apprentice Dec 19 '16 at 04:07
-
read this http://stackoverflow.com/a/10717999/1651993 . May be your requirements are different but usually I avoid using Select, Activecell etc. – nightcrawler23 Dec 19 '16 at 04:29