Thread
:
using match in vba without assigning a cell
View Single Post
#
4
Posted to microsoft.public.excel.programming
Don Guillett[_4_]
external usenet poster
Posts: 2,337
using match in vba without assigning a cell
what is begbase??? If a range try [begbase]
--
Don Guillett
SalesAid Software
"Papa Jonah" wrote in message
...
I am trying this:
sb=application.match(begbase,a2:a20)
and not having any success.
Did I misunderstand?
"Don Guillett" wrote:
to use match
sb=application.match
--
Don Guillett
SalesAid Software
"Papa Jonah" wrote in message
...
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
Reply With Quote
Don Guillett[_4_]
View Public Profile
Find all posts by Don Guillett[_4_]