Excel VBA Help

[A[L]C]

Hi all,

I have the following which obviously doesnt work, but should help show what IM after:

If strRemoveCriteria = strRemoveValue Then
    blah blah

strRemoveCriteria and strRemoveValue are populated by cell values eg

strRemoveCriteria - left(strName, 5)
strRemoveValue - Admin


I want the code to relpace the value and make it actual code - ie the code would be

If left(strName, 5) = "Admin" Then


Really hard to explain this!!!