Rows columns to repeat while printing in a workbook

S

Subodh

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.
 
D

Don Guillett

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top