Prev: random selection of rows
Next: What VBA function returns cell 2 from which cell 1 gets its value?
From: JLatham on 24 Mar 2010 00:05
Your best solution is to copy rows 1 through 5 from Sheet1 into all other
sheets and use Page Setup to repeat rows 1:5 on each sheet when it is printed.

If the entries in rows 1:5 of Sheet1 change often and you need to have the
same entries on all other sheets, then set up the entries on the other sheets
to link back to the appropriate cell on Sheet1. For example, in cell A1 of
each of the other sheets, you could put the formula:
=Sheet1!A1
You can then easily 'fill' that formula over and down the sheet for as many
columns and down to row 5 so that whatever is on Sheet1 in rows 1:5 always
appears on the other sheets.


"Subodh" wrote:

> I want to make code to make all the sheets have same ROWS TO REPEAT AT
> TOP on all the sheets of a workbook. ie. all the sheets in a work book
> should have row1 to row5 of sheet1 to repeated at the top.
> But, they cannot be made?
> The Sheets to repeat on top is only for sheet
> I want to make the sheet code for the workbook.
> .
>
 | 
Pages: 1
Prev: random selection of rows
Next: What VBA function returns cell 2 from which cell 1 gets its value?