| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| split post code (zip code) out of cell that includes full address | Excel Discussion (Misc queries) | |||
| Drop Down/List w/Code and Definition, only code entered when selec | Excel Worksheet Functions | |||
| Generic protect/unprotect code through buttons and code? | Excel Programming | |||
| do anybody have a sample code for executing excel macro from vb code?<eom | Excel Programming | |||
| stubborn Excel crash when editing code with code, one solution | Excel Programming | |||
Linear Mode
