Top Border in Excel footer

  Chillie 14:38 26 Jul 08


I hope someone can point the way. Created a macro to insert a footer to a worksheet using a range which is on a different sheet (same workbook). I added a top border to the footer details, but cannot get it to display.

Maybe this is not possible, and I may have to create an image.

Any assistance would be appreciated, even if it is to say 'no chance'.

BTW using Office 03.

Many thanks

  VoG II 17:06 26 Jul 08

As far as I know this is not possible.

Suggestion: create your footer in Word which allows much more flexibility with Footers then copy and paste in your table from Excel.

  Chillie 21:27 26 Jul 08

Lived in hope that you would be able to assist.

Shall try your suggestion tomorrow.

Just to be clear: (1) create a footer e.g. "copyright 1234" with a top border (2) copy to footer-cell in Excel?

Will report.

Many thanks again


  Chillie 10:51 27 Jul 08

Will take your advice and create the spreadsheet to act almost as a database (not really, I know!); then as you suggested link the contents from Excel into the presentation in MS Word.

Nevertheless, thank you for pointing the way



This thread is now locked and can not be replied to.

Intel Coffee Lake 8th-gen Core processors release date rumours

1995-2015: How technology has changed the world in 20 years

Framestore’s haunting post-WWII title sequence for new BBC series SS-GB

How to install MacOS Sierra on an older Mac: Get Sierra running on Macs & MacBooks from before 2009