Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Sheet number change
I have a multi sheet workbook and need to change the worksheet numbers on each page. I have tried the following, but it doesn't work. Any help appreciated! Sub NewNumber() nSheet = 2 Do While nSheet <= Sheets.Count For I = 2 To 3 Sheets(nSheet).Select Cells.Replace What:="1 '!$C$13", Replacement:="(I) '!$C$13", LookAt:=xlPart, SearchOrder _ :=xlByRows, MatchCase:=False nSheet = nSheet + 1 Next I Loop End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I change the Excel sheet tab bar to display more sheet tabs | Excel Discussion (Misc queries) | |||
change page number in the same sheet | Excel Discussion (Misc queries) | |||
change info in other cells when i change a number in a drop list? | Excel Discussion (Misc queries) | |||
How do I change the number on copy sheet so I don't have to renam | Excel Worksheet Functions | |||
Change workbook sheet reference using cell A1 to change a vairable | Excel Worksheet Functions |