View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
David B David B is offline
external usenet poster
 
Posts: 32
Default 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.