View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
RichardSchollar[_2_] RichardSchollar[_2_] is offline
external usenet poster
 
Posts: 76
Default 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