Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Where to locate reference
Where may I locate the reference to using the various
parameters with worksheet functions as methods such as FIND, SUMIF, etc. I see answers describing values like "what=:" and "lookin" and the like. Where are these documented? Thanks. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Where to locate reference
Those are called named ranges, but they are only used with procedures built
in VBA or VB. For the worksheetfunctions, you don't use names - arguments are passed by position. So you just use Excel help for those to identify the arguments. -- Regards, Tom Ogilvy "Lee Hunter" wrote in message ... Where may I locate the reference to using the various parameters with worksheet functions as methods such as FIND, SUMIF, etc. I see answers describing values like "what=:" and "lookin" and the like. Where are these documented? Thanks. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Where to locate reference
Those are called named ranges,
should say Those are called named arguments, -- Regards, Tom Ogilvy "Tom Ogilvy" wrote in message ... Those are called named ranges, but they are only used with procedures built in VBA or VB. For the worksheetfunctions, you don't use names - arguments are passed by position. So you just use Excel help for those to identify the arguments. -- Regards, Tom Ogilvy "Lee Hunter" wrote in message ... Where may I locate the reference to using the various parameters with worksheet functions as methods such as FIND, SUMIF, etc. I see answers describing values like "what=:" and "lookin" and the like. Where are these documented? Thanks. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Where to locate reference
Thanks Tom,
and I should have more properly called them Methods, rather than worksheet functions. In any case for the FIND method, for example: Set c = .Find(2, lookin:=xlValues) Where is "lookin:=" defined and where is "xlValues" explained? It appears to me as if each method has it's own set of named arguments,as: Worksheets("Sheet1").Columns("A").Replace _ What:="SIN", Replacement:="COS", _ SearchOrder:=xlByColumns, MatchCase:=True doesn't use "lookin:=" and FIND doesn't use "SearchOrder". I can't locate this in either Excel or VBA help or in the Language or Forms reference manuals. Where are they hidden? Thanks, again. -----Original Message----- Those are called named ranges, should say Those are called named arguments, -- Regards, Tom Ogilvy "Tom Ogilvy" wrote in message ... Those are called named ranges, but they are only used with procedures built in VBA or VB. For the worksheetfunctions, you don't use names - arguments are passed by position. So you just use Excel help for those to identify the arguments. -- Regards, Tom Ogilvy "Lee Hunter" wrote in message ... Where may I locate the reference to using the various parameters with worksheet functions as methods such as FIND, SUMIF, etc. I see answers describing values like "what=:" and "lookin" and the like. Where are these documented? Thanks. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula to reference another worksheet, locate data, then record i | New Users to Excel | |||
locate a cell value within a range and return its reference | Excel Discussion (Misc queries) | |||
How do I locate a circular reference error? | Excel Worksheet Functions | |||
Locate first number that exceeds reference value | Excel Worksheet Functions | |||
How do I locate a highlighted cell as a cross hair type reference | Setting up and Configuration of Excel |