Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Rows columns to repeat while printing in a workbook
I want to have same text to repeated at the top of all the sheets of a
workbook. The text also contains some images and keep on changing. But i cannot get that repeated in the top of all sheets because i tried from pagesetup-Print-Rows to repeat at top. This didn't work on grouped sheets. Also, I cannot link the data from the main sheet like =Sheet1!A1 because there are also images in the sheet and it cannot be linked. I think this cannot be done by using Excel and I cannot get a code for VBA. The code requires With ActiveSheet.PageSetup ..PrintTitleRows = "$8:$13" End With But, I cannot get the code to work by giving the sheet reference. Sheet1!"$8:$13" didn't work in this case. Any useful help will be heartly taken. Thanks in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Repeat rows on top - in worksheet - not printing! | Excel Worksheet Functions | |||
Repeat printing rows in multiple worksheets | Excel Discussion (Misc queries) | |||
printing issue - want to repeat two rows and also 5 rows in column | Excel Discussion (Misc queries) | |||
Title Cut Off if Rows to Repeat & Columns to Repeat are Both Selec | Excel Discussion (Misc queries) | |||
Colums and Rows to repeat in Printing | Excel Programming |