VBA to change cell alignment

hi,

I have searched but have not found...please help.

I would like the contents of cell C1, which happens to be numbers, to align left if cell A1=0, align centre if cell A1 =1 and align Right if cell A1 =2. I realize this must be terribly easy...thanx a lot for any help..


I STILL CANNOT SEEM TO REPLY TO MY GOOD SAMARITANS...I HOPE YOU GUYS SEE THIS SOMEHOW

THANX TO BURAN, RIORAN AND JOHN DAVIS. YOU HAVE ALL BEEN A GREAT HELP!!

OKAY..LET ME BE SPECIFIC...I USED BURAN'S IDEA...WORKS GREAT..THANX A LOT!!