| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
User Defined Range
I have a UDF that calculates the percentage of a value (rVal) based on
a sum of similar values (rTot). It returns a value multipled by another value (rTarg) and rounded. Function FigurePert(rTot As Integer, rVal As Integer, rTarg) As Variant xx = (rVal / rTot) FigurePert = Round(xx * rTarg, 0) End Function I would like rTot be the value of a given range that the user chooses by a defined Name or selected. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| User-defined range for graph | Excel Discussion (Misc queries) | |||
| How to: User Form to assign a user defined range to a macro variab | Excel Programming | |||
| User-defined data type; Error: Only User-defined types... | Excel Programming | |||
| external range in VBA (user defined formula) | Excel Programming | |||
| external range in VBA (user defined formula) | Excel Programming | |||
Threaded Mode
