I'm sure this must have been asked before but I've done a quick search of the forum and couldn't find what I wanted. I need the code for finding out if cell A1 contains a "Y" and if it does then insert a chart. I have the code for inserting a chart but not too sure on the code for checking if "A1" contains "Y" and if it does how to link it to the add chart code. Hope this makes sense and someone can help.
thanks
Matt
thanks
Matt