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

Similar Threads

Sheet and workbook code: All sheets should have row 1 to 5 of Sheet1to be repeated at top 3
Repeat the titles across multiple sheets of a workbook. 6
To get the same header,footer and sheet titles across multiple sheetsof a workbook. 1
Make the same titles repeated in multiple sheets of a workbook 1
All sheets in workbook have same rows to repeat at top 1
Macro to setup Rows to Repeat at the Top 5
Sound repeats unending until closing workbook 2
Insert rows in grouped sheets 2

Top