One more thing that might work for me ...

I would like to read what the current value of a footer
is - i.e. I would like to do this:

FooterVal = _
ActiveWorkbook.Sheets(1).PageSetup.RightFooter.val ue

This does not work though - I get an "object required"
error.

Any other thoughts?

Thanks - and this will be my last "footer" question!!

Remove the .Value. The RightFooter is not an object, just a string
property...

FooterVal = _
ActiveWorkbook.Sheets(1).PageSetup.RightFooter

Regards,

Juan Pablo González

"Andrew" wrote in message
...
One more thing that might work for me ...

I would like to read what the current value of a footer
is - i.e. I would like to do this:

FooterVal = _
ActiveWorkbook.Sheets(1).PageSetup.RightFooter.val ue

This does not work though - I get an "object required"
error.

Any other thoughts?

Thanks - and this will be my last "footer" question!!

There is no Value property, just remove it.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Andrew" wrote in message
...
One more thing that might work for me ...

I would like to read what the current value of a footer
is - i.e. I would like to do this:

FooterVal = _
ActiveWorkbook.Sheets(1).PageSetup.RightFooter.val ue

This does not work though - I get an "object required"
error.

Any other thoughts?

Thanks - and this will be my last "footer" question!!

Of course --- thank you guys!!

-----Original Message-----
There is no Value property, just remove it.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Andrew" wrote in
message
...
One more thing that might work for me ...

I would like to read what the current value of a footer
is - i.e. I would like to do this:

FooterVal = _
ActiveWorkbook.Sheets(1).PageSetup.RightFooter.val ue

This does not work though - I get an "object required"
error.

Any other thoughts?

Thanks - and this will be my last "footer" question!!


.