Thanks Paul! This did work to put the footers in. I even figured out how
to add a few more things. Really appreciate your help!
Kelly Ann
On Wednesday, January 10, 2018 at 1:08:57 PM UTC-6, Paul Schreiner wrote:
>
> What does your macro look like?
>
> I recorded a macro, then "cleaned it up"
On Fri, 1/12/18, 'Kenyatta Freed' via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$ macros won't run as written
To: excel-macros@googlegroups.com
Date: Friday, January 12
On Wed, 1/10/18, Paul Schreiner wrote:
Subject: Re: $$Excel-Macros$$ macros won't run as written
To: "excel-macros@googlegroups.com"
Date: Wednesday, January 10, 2018, 10:08 PM
What
does your macro look like?
I
recorde
What does your macro look like?
I recorded a macro, then "cleaned it up".the result being:
Sub PageFormat
ActiveSheet.PageSetup.LeftFooter = "&D"
ActiveSheet.PageSetup.RightFooter = "&Z&F" End Sub
it seems to work great in Excel 2010
Paul-
“Do all the