Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
why doesn't this work?
Can anyone say what's wrong with this code?
Dim myRange As Range For n = 5 To 10 If Sheets("stddev").cells(n, 11).Value < "" Then Set myRange = ActiveSheet.Range(cells(n, 10), cells(n, 11)) Sheets("stddev").cells(n - 2, 8).Value = _ Application.WorksheetFunction.StDev(myRange) End If Next n This is what I have in cells J en K: J K C4 C10 C11 C16 C17 C23 C24 C30 C31 C38 C39 C45 C46 C52 C53 C60 So the idea is to look in cells J en K and then calculate standard deviation of the range cells J en K are refering to( in this case range C4:C10). The result should be placed in cell H3. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
why doesn't this work?
For n = 5 To 10
If Sheets("stddev").cells(n, 11).Value < "" Then Set myRange = ActiveSheet.Range(cells(n, 10).value & ":" & _ cells(n, 11).Value) Sheets("stddev").cells(n - 2, 8).Value = _ Application.WorksheetFunction.StDev(myRange) End If Next n -- Regards, Tom Ogilvy "Nick" wrote in message om... Can anyone say what's wrong with this code? Dim myRange As Range For n = 5 To 10 If Sheets("stddev").cells(n, 11).Value < "" Then Set myRange = ActiveSheet.Range(cells(n, 10), cells(n, 11)) Sheets("stddev").cells(n - 2, 8).Value = _ Application.WorksheetFunction.StDev(myRange) End If Next n This is what I have in cells J en K: J K C4 C10 C11 C16 C17 C23 C24 C30 C31 C38 C39 C45 C46 C52 C53 C60 So the idea is to look in cells J en K and then calculate standard deviation of the range cells J en K are refering to( in this case range C4:C10). The result should be placed in cell H3. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to update a column in a work based on another work sheet | New Users to Excel | |||
how can i automatically generate work order numbers from work orde | Excel Discussion (Misc queries) | |||
flash object dont work in my excel work sheet | Excel Discussion (Misc queries) | |||
Counting dates in multiple work sheets and work books | Excel Discussion (Misc queries) | |||
Is there away to keep "auto save" from jumping to the first work sheet in the work book? | New Users to Excel |