does
Code:
myvariant = c
not work, or please put more detail what you are trying to achieve

as this thread is about vba it should be in office development