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.

Rows columns to repeat while printing in a workbook
 

If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Subodh" wrote in message
...
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.