sheet title

[mn12]

how do I set the same title for some sheets in excel?

thank You,in advance

 

[xlbo]

Not entirely sure what you mean but try looking at the "rows to repeat at top" feature of the pagesetup

Rgds
Geoff
"Some cause happiness wherever they go; others whenever they go."
-Oscar Wilde

 

[bryanbayfield]

Do you mean the same header for a selection of sheets?

Select an array of sheets (click on the sheets you want while at the same time depressing the shift key), then select page setup, header/ footer tab.

 

[mn12]

I have a sheet array (of 3 sheets)and I want the same title to appear at the top of each sheet.
I tried to use "rows to repeat at top" of pagesetup like that:
ActiveSheet.PageSetup.rowstorepeatattop ="aaaa"
but it really doesn't work.

any ideas would be much appreciated.

 

[bryanbayfield]

Probably because you're using the activesheet accessor. Try using Sheets(Array("Sheet1", "Sheet2", "Sheet3&quot) instead.

 

[mn12]

this is what I have wrote:

ActiveSheet.PageSetup.LeftHeader = "aaa"--> this line I want at the top

Sheets(2).Select
Sheets(3).Select
Sheets(Array(1, 2, 3)).Select
Sheets(1).Activate

I get the "aaa" on the first page only.

I tried also :ActiveSheet.PageSetup.rowstorepeatattop="aaa"
but the "aaa" doesn't appear at all.

What is the problem here???

 

[bryanbayfield]

rowstorepeatattop isn't a valid property so I ain't surprised you've had probs!

Dim sh As Worksheet
For Each sh In Sheets(Array("Sheet2", "sheet3"))
    sh.PageSetup.PrintTitleRows = "$1:$1"
    Next

Change your array of sheet names as necessary. The problem was you've stuck to using

ActiveSheet

which means you will change the left header only of the ...

ActiveSheet