lundi 22 mai 2017

Excel VBA: If cell contains "text1", "text2" or "text3" then print different sheets

I need excel VBA coding which does this:

If cell A1 contains the text "apple", "orange" or "banana" then print sheet1 and print sheet2

Elseif cell A1 contains the text "mango" or "pineapple" then print sheet3 and sheet4.

Thanks in advance!

Aucun commentaire:

Enregistrer un commentaire