Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
CONDITIONAL STATEMENT | Excel Worksheet Functions | |||
Conditional Statement | Excel Worksheet Functions | |||
Conditional statement | Excel Programming | |||
conditional statement | New Users to Excel | |||
Conditional Statement? | Excel Programming |