How to change font in a macro that inserts a formula in a footer

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I've written the following macro (this is the operative part of it) to insert
the file name AND path into the left footer of my Excel 2000 spreadsheet:

With ActiveSheet.PageSetup
.LeftFooter = ActiveWorkbook.Path
.LeftFooter = ActiveWorkbook.FullName
End With

The macro works fine. HOWEVER, I want to change the point size of the font
from "normal" to .08. I've tried entering a line code of "&08", but it
doesn't work, as this is intended to change text. Since the macro is
entering a formula, the "&08" doesn't work.

Any solution?

Thank you in advance.
 
Back
Top