VBA code to sum
 

Hi all

i have column B which has around 600 values when my no.of.cycles (n) =
1,
then it will be B & C for n = 2, where n is specified by the user.

according to n i want to calculate this formula for the whole column,

=Round(SUM(Tabelle2!B3:B12)/counta(Tabelle2!B3:B12)-SUM(Tabelle2!B2:B11)/counta(Tabelle2!B2:B11);2)

so when n= 1 i want to take column B, and for n = 2 column B & C and so
on.
could anyone help me in programming this

advance thanks for ur help
santhosh.