My query coding is below
Function SplitNames(Val as String) as String
Dim arr1 As Variant
arr1 = Array("Mr","Mrs","Dr")
Dim count as integer
Above my coding is working perfect in the eqaul(if(val=arr1(count)) then) BUT its not working in Not equal. I need to my out put be not Mr or Mrs or Dr.
Please help me to solve above my issue.
When iam using most of the time Not equal is not working <>