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

Bettergains wrote:

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