- 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
55") .... 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?
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
55") .... 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?