LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 59
Default Making a footer 2 lines

Ok currently I have to cells with information. I currenlty have it set to
put one in the left and one in the right footer. I need to put them both in
the let footer one over the other. Any one have any ideas. This is my
current code. Thanks

'Left
Sheets("Report").PageSetup.LeftFooter = Sheets("Data
Entry").Cells(248, 3)
'Right
Sheets("Report").PageSetup.RightFooter = Sheets("Data
Entry").Cells(246, 3)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
inserting Long Text Lines in Footer Janet A. Thompson Excel Discussion (Misc queries) 1 October 28th 09 09:51 PM
Making a vertical list from a rectangular range, with no empty lines vsoler Excel Worksheet Functions 10 February 25th 09 03:55 AM
Making Static Lines in Chart anshu[_2_] Charts and Charting in Excel 1 July 24th 07 08:51 AM
Making two lines into one nabanco Excel Worksheet Functions 3 July 12th 07 08:22 PM
Print signature lines as footer goss[_31_] Excel Programming 1 August 10th 04 08:35 AM


All times are GMT +1. The time now is 04:23 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"