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