Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Optional Arguements for Functions
I want to build a function which takes two optional arguements. If Y
and Z are note provided, I would like to make them equal to 1. How do I state this within the function? They way I have it below will force them to 1 regardless. Private Function New(X As Double, Option Y As Double, Optional Z As Double) 'if Y and Z are not provided then force them to value of 1 Y = 1.0 Z = 1.0 New = X*Y*Z --- Message posted from http://www.ExcelForum.com/ |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Too many arguements? | Excel Worksheet Functions | |||
how can i have more than 30 arguements in a SUM | Excel Discussion (Misc queries) | |||
Nesting Functions with more than 7 arguements | Excel Worksheet Functions | |||
OR Function with more than 30 arguements | Excel Discussion (Misc queries) | |||
Too many arguements | Excel Discussion (Misc queries) |