i am using "InStr(1, ActiveCell.Text, search)" code. how do i make the code so it is not case sensitive.
example
ActiveCell.Text = "The Malt Shoppe"
search = "malt"
i am using "InStr(1, ActiveCell.Text, search)" code. how do i make the code so it is not case sensitive.
example
ActiveCell.Text = "The Malt Shoppe"
search = "malt"
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks