Is there a way to format my value "a" without using a "with" statement, and if not could someone give me a lead on how to incorporate it into this If Statment. I must be missing something in the help files.
Steve
If Not Intersect(Target, exampleCells) Is Nothing Then Target.Value = "a" ' .Font.Name = "Marlett" End If