I am new to using Macros and am looking for info on creating macros which will allow me to use if-then-else statements based on set variables and then print out the results of the conditional statement. For example: if content of cell A1=var1, print statement1, elseif content cell A1= var2 print statement2, elseif content cell A1= var3 print statement3 and so on up to var12. All content will be text If someone could point me in the right direction to learn about this it would be greatly appreciated, Thanks, Ross K.