Perfect, I would never have found that! From the help file it looks as
though that could be useful elseware...

Thanks
LandesMD

"Andy Pope" wrote:

activesheet.pagesetup.centerfooter = "Hello" & vblf & "Today"


LandesMD wrote:
One further thing. Is there any way to get a character return in the footer
using VBA??? Or enter a second line of text??

"LandesMD" wrote:

etc...
Andy Pope, Microsoft MVP - Excel
http://www.andypope.info