Hi
Is it possible when printing in excel, to have a cell as a footer. I know it's possible to have the page, the file name, the sheet name. But for a cell ????
Thank's
Philippe
Hi
Is it possible when printing in excel, to have a cell as a footer. I know it's possible to have the page, the file name, the sheet name. But for a cell ????
Thank's
Philippe
Good afternoon Hellboy
Certainly is - but you will need to use VBA to achieve it.
With ActiveSheet.PageSetup
.LeftFooter = Worksheets("Sheet1").Range("A1").Value
End With
This would do the trick. Obviously, if you want the footer on the right or in the centre you would use the CenterFooter or RightFooter property.
HTH
DominicB
Hi dominicb
Wow ! Thank's a lot.
Philippe
Hi Philippe
You're welcome. And thanks for the feedback.
DominicB
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks