PDA

View Full Version : [SOLVED] Format a value



lucas
07-09-2005, 12:43 PM
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

Jacob Hilderbrand
07-09-2005, 12:50 PM
Target.Font.Name = "Marlett"

lucas
07-09-2005, 12:56 PM
Thanks Jake, been racking my brain.