Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
log based on cell values
Hi, all
Can someone explain to me why this code doesn't work? I get a 424 error and the debugger points to the line I indicate below: Sub volatility() Sheets("HistoricalVolatility").Select z = 2 + 1 vol = 0 Count = 0 Do While Cells(z, 7) < "" vol = vol + Log(Cells(z, 7).Value) / Log(cell.Offset(-1, 0).Value) ' here's the prob Count = Count + 1 z = z + 1 vol = vol / Count Loop Sheets("Options").Range("B9").Value = vol End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting values in one cell based on values in another | Excel Discussion (Misc queries) | |||
Copy values from a cell based on values of another cell | Excel Discussion (Misc queries) | |||
How to assign values to a cell based on values in another cell? | Excel Worksheet Functions | |||
VAB to copy cell values into new Sheet, Overwrite if needed and based off of Cell Value in a column | Excel Programming | |||
Search/Filter to find values in another range based on two cell values | Excel Programming |