|
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) |
Making a footer 2 lines
Sheets("Report").PageSetup.LeftFooter = _
Sheets("Data Entry").Cells(248, 3) & chr(10) & _ Sheets("Data Entry").Cells(246, 3) -- Regards, Tom Ogilvy "Kiba" wrote: 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) |
| All times are GMT +1. The time now is 08:26 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com