| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating an AVERAGE next to the top of a selection
This is what I have so far and, being used to the .NET environment and
not having its excellent documentation... Well, I can't figure it out. My function is extremely simple, but not yet complete because it has the target cell hard-coded. I want the cell to be the in the next column to the top of the selection. So if the selection is from C17:C33 then the following should be created in cell D17: =AVERAGE(C17:C33) My function's code so far: Range("g20") = Application.WorksheetFunction.Average(Application. Selection) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Creating values based on selection from drop down box | Excel Discussion (Misc queries) | |||
| Creating Average IF | Excel Worksheet Functions | |||
| Calculate average based on user selection | Excel Discussion (Misc queries) | |||
| Help creating a macro to copy and paste a certain selection | Excel Discussion (Misc queries) | |||
| creating an average? | Excel Discussion (Misc queries) | |||
Threaded Mode
