I am trying to use the match function to assign a value to a variable.
I do not want to put the match syntax in a cell. I just want the result to
be able to be referred to later in an If then statement. I have tried:

startbase = Match(begbase, "a:a")
but that does not work.

Any suggestions would be appreciated.
TIA