You're variables searchValue1 & searchValue2 are set as strings and therefore the result of the formula is an error.
Change them to Long data types and it should work.
BSB.![]()
Dim searchValue1 As Long Dim searchValue2 As Long
You're variables searchValue1 & searchValue2 are set as strings and therefore the result of the formula is an error.
Change them to Long data types and it should work.
BSB.![]()
Dim searchValue1 As Long Dim searchValue2 As Long
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks