What is INP?

Do you mean?

With Sheets("Sheet1").PageSetup
.RightHeader = "&""Arial,Bold""&36" & Cells(2, 7).value
End With

"Marty" wrote in message
...
Hello.

This should be an easy one for someone. I want to take the contents of
cell
INP.Cells(2,7) and put it into the right header of a worksheet so that
what
is in the header changes if the cell contents change.

Here is the code I'm trying to use:

With Sheets("Sheet1").PageSetup
.RightHeader = "&""Arial,Bold""&36" & INP.Cells(2, 7)
End With

It doesn't return an error, but also does not put anything in the header.
Can anyone spot what's wrong with it?

Thanks,