View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] cuocosellc@gmail.com is offline
external usenet poster
 
Posts: 4
Default 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