Make the first row to be fixed and to be printed in each page
To fix the first row from scrolling:
Rows("2:2").Select ActiveWindow.FreezePanes = True To print row 1 of the current sheet on each printed page, use the following code: activeSheet.PageSetup.PrintTitleRows = "$1:$1" Good Luck ! "ken" wrote in message ... Dear all, I want to fixe the first rows and will be showed whatever i scrolled and the row to be printed in each page e.g. Name Surname aa xx bb zz cc kk . . I want the first row will be show in all printed |
All times are GMT +1. The time now is 02:43 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com