How to deate Conditional statement for the header
On 11 Jan, 16:25, WuiChi wrote:
I have been task to have an image appear in the Header if a cell contains a
value. *For instace if A8 is not null then have "SOLD" appear in the header.
I am not use to programming in Excel. I usually work with Access. *So if you
could lead me through this I would appreciate it . * *I am using office 2003 *
Thank you
Hi
Something like the following maybe:
With Sheets("Sheet1")
If Not IsEmpty(.Range("A8").Value) Then
.PageSetup.LeftHeader = "SOLD"
End If
End With
Richard
|