Application.match--Documentation?

[Guest]

Hello:
I am using application.match code that copies formats (or uses any
xlPaste... constant) and I love it. But I don't understand it much and can't
find documentation on it. One question I have is: Can I tweak the code to
match only specific columns in a range/region? Or does it always apply the
match against all the continguous columns per row?

Also, can't find it via the object browser when looking for application
class, worksheet, application or simply looking for a match method. Where
the heck is it?

Thanks for your expertise~

 

[Dave Peterson]

Take a look in Excel's help (not VBA's help) for =match().

(You're using a worksheet function inside your code.)

Debra Dalgleish has some notes about =match() and =index(match()) at:
http://www.contextures.com/xlFunctions03.html

 

[Tushar Mehta]

It's an XL function available in VBA.

If you search XL VBA help for 'match' (w/o the quotes) you will be
directed to, among other topics, 'Using Microsoft Excel Worksheet
Functions in Visual Basic' That, in turn will link to 'List of
Worksheet Functions Available to Visual Basic' Click the button for M
and you will find MATCH.

With some version of XL MS changed the access to worksheet functions to
Application.Worksheetfunction.{function} and stated that it would
depracate Application.{function} However, it hasn't happened and I can
no longer find references to it deimplementing Application.{function}

Also, and AFAIK this applies only to Match, MS for some strange reason
(might even be a bug or an oversight) implemented the 'no match found'
handling of Application.Match and Application.Worksheetfunction.Match
differently. Don't ask me why. It did. And, any number of people
have written code that exploits the difference.

And, all you wanted was a little documentation on Match. {g}

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions