runtime error '1004':Unable to get match property of worksheetfunc

S

SteveP

Run-time error '1004': Unable to get the Match property of the
WorksheetFunction class
in response to
map2 = Application.WorksheetFunction.Match(map,
Worksheets("pcmap").Range("B2:B13"), 0)
in an Excel 2003 macro.
Does anyone know why? Help text seems to say it's OK.
 
S

Steve Schapel

Steve,

The focus of this newsgroup is macros in Microsoft Access, the database
program. You will have a better chance of a good answer to your question if
you re-post to an Excel related newsgroup.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Worksheet function match - run time error 3
Excel. VBA match doesnt work while WS does 0
unable to get match property of WorksheetFunction class 3
Match WorksheetFunction Question 3
Match problems. 2
Worksheetfunction MATCH 2
Getting a the position of a single item in an array 5
Another runtime 1004 error 2

Top