Excel. VBA match doesnt work while WS does

Joined
Jun 1, 2017
Messages
1
Reaction score
0
Ok..

Match () works fine
I see you can't use names, and have to tell it what sheet to use. I set the range to a variant... worksheets ("calendar").range ("D2:D55") .... then I used the worksheet function xlmatch variant, intDate, 0 where intDate is 46887 . I get 1004 err. What else does the VBA function need?
 

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

Top