I am trying to create a macro that will automatically sum a variable
range of rows. Simple example.
Price Qty
1 10
4 20
6 30
10 40
------
5 7
17 10
19 4
25 3
30 1
36 0
The rows of data will always start on the same row so I have tried
just doing a CRTL+ down arrow. How do you convey, in VB Excel, to
move down 2 additional rows and then sum the range above?
It would be interesting to see some code for doing this if the start
row is different but that's not in the immediate focus of my question.
I tried doing this by recording the macro and doing the keystrokes
necessary to get the result, but I am at a loss on what to do to edit
the VB code of the macro to achieve my goal so it works on variable
row ranges.