I am trying to use the match function within vba without using a cell.
The following is how I was told to do it. I am trying to match the
value of begbase (which is "10/1/97" in this case).
Dim sb As Variant
sb = Application.Match(begbase, Range("a2:a" & causerows))
What I get is Error 2042. I don't know what that is. Can some one
either tell me what it is, or better yet, how to solve the problem?
TIA
Bookmarks