Read a current footer value

A

Andrew

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.value

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

Any other thoughts?

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

Juan Pablo Gonzalez

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

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

Regards,

Juan Pablo González
 
B

Bob Phillips

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)
 
A

Andrew

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)




.
Click to expand...
 
Top