Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Add-In Visibility
I've written a user-defiend function, meant to be called from a cell via "=",
have put it in an .xla file, have loaded the .xla via Tools | Add-Ins, but it is not visible to the cell unless I include the module's name. The formula box "sees" it but doesn't interact with it: Doesn't Work: =AverageB(rRng,sLower,sUpper). Works: =mdlAverageB.AverageB(rRng,sLower,sUpper). I don't think this is a coding issue, but in the following, the declarations haven't been included for brevity's sake: Public Function AverageB(rRng As Range, sLower As Single, sUpper As Single) As Single ' TPA:DC.J(254).CSR():20080123W1807E:20080123w1842e For Each r In rRng ' Standard Average for future reference - is not returned by fnc intCount = intCount + 1 sglSum = sglSum + r.Value ' Bound Average If r.Value = sLower And r.Value <= sUpper Then intAvgBCount = intAvgBCount + 1 sglAvgBSum = sglAvgBSum + r.Value End If Next ' Standard Average for future reference - is not returned by fnc sglAvg = sglSum / intCount 'Returns std Avg()'s value AverageB = sglAvgBSum / intAvgBCount End Function Grazie, -- Trent Argante [DC.J(254)] |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Textbox text visibility | Excel Discussion (Misc queries) | |||
Custom Toolbar Visibility | Excel Discussion (Misc queries) | |||
Toggling Visibility of items with VBA | Excel Worksheet Functions | |||
Visibility of active cell. | Excel Discussion (Misc queries) | |||
Is it possible to change visibility of Trendlines on a Scatter Gra | Charts and Charting in Excel |