Concatenating strings into a variable
Can't seem to find this anywhere and it should be simple.
I have an array ActiveEmp "John", "Joe", "Bob", etc.
I have variables named "UPD_John", "UPD_Joe", "UPD_Bob", etc.
in looping through the array, I want to test the variable true/false
If "UPD_" & ActiveEmp(i) = True Then
"UPD_" & ActiveEmp(i) does equal "UPD_John", etc. but it's not recognized as a variable that I can test for true/false
Any help would be appreciated.
Thanks
|