Is there a way to use an IF statement in the Header? For example could I
change the Header based on a "X" in a certain cell?

Frank,

The answere is Yes.

Select TOOLS|Macros

Turn your record macros on.

Enter a header, then turn record macros off.

Now you have captured the code to create headers.

Go to the VBA editor and use some IF-Then code to insert the header you
want, or the named range of the header you want.




"Frank E" wrote in message
...
Is there a way to use an IF statement in the Header? For example could I
change the Header based on a "X" in a certain cell?