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

On 11 Jan, 16:25, WuiChi <Wui...@discussions.microsoft.com> 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 ifyou
> 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