Range Formula question
I'm new to VBA Excel and need some help creating some code.
I want to sum two columns of data; the number of rows with data is variable.
First sum=: cell F10 through the end of the range (Which I would normally
select by using shift/ctrl/down arrow). The Sum of this range needs to be in
cell G2.
Second Sum: The second sum needs to be the total of the range that starts 3
rows below (i.e. 2 blank rows) through the end of the data in that column
(Again, I use shift/ctrl/down arrow). This sum needs to be in cell G6.
Am having a tough time writing the code correctly to select the two
ranges....thanks for any hints you can provide.
|