Read a current footer value
 

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!!

Read a current footer value
 

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!!

Read a current footer value
 

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!!

Read a current footer value
 

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!!


.