Djblois
04-03-2007, 12:34 PM
I am trying to run code if the text in the Left Header is Grocery Division and I can't get it to work. Here are the different ways I have tried -
leftHeaderText = "Grocery Division"
If ActiveSheet.PageSetup.LeftHeader = leftHeaderText Then
If ActiveSheet.PageSetup.LeftHeader = "Grocery Division"
If ActiveSheet.PageSetup.LeftHeader = "&""Arial,Bold""&10Grocery Division"
The last one I tried because that is the formating I set.
leftHeaderText = "Grocery Division"
If ActiveSheet.PageSetup.LeftHeader = leftHeaderText Then
If ActiveSheet.PageSetup.LeftHeader = "Grocery Division"
If ActiveSheet.PageSetup.LeftHeader = "&""Arial,Bold""&10Grocery Division"
The last one I tried because that is the formating I set.