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. |
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. |
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. |
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. . |
All times are GMT +1. The time now is 02:53 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com