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.
|