Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Average command
Hi,
How can I do the following (I guess for you it will be simple):) I would like to use the Average command as follow: I called cell A1: RSI1 So the Average command will be: Average(the cell that I'm right now : the cell that I'm right now - RSI1). How can write this command? Thank you, Haim. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Average command
you wil get an error as you will be in a circular reference
at least if you try to do this with no VBA! using vba: sub TryThis() dim Answer as long Answer Application.WorksheetFunction.Average(Range(Active Cell.Address Range("RSI1"))) end su -- Message posted from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
One command in one cell initiating another command in another cel. | Excel Worksheet Functions | |||
command code ( GOTO command) in formula | New Users to Excel | |||
Pivot Table Error Message - "Command Text not set for command obje | Excel Discussion (Misc queries) | |||
Find monthly average but have average automatically configured | Excel Discussion (Misc queries) | |||
Using average command with a 0 in the column | Excel Worksheet Functions |