VBA Copy Sum formula down column with multiple ranges

Hello

I am trying to create a macro to SUM two columns (K and L) and repeat that sum every 34 rows. I have data from K2:K30 and L2:L30. So, I would like the sum to be on K31 and L31. Then, skip 3 rows (making it 34 rows) and repeat the process. Here is the code that I am currently using, but instead it sums the three rows rather than skipping to the next range:

Please Login or Register  to view this content.

I would deeply appreciate any help as I have not been able to solve yet.

Many thanks in Advance!

http://www.excelforum.com/excel-prog...83#post2996083

http://www.excelforum.com/excel-prog...83#post2996083