| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sheet Name
I need a macro that will change the names of the sheets in a workbook equal
to a given cell in those sheets |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Sheet Name
BOONER wrote:
I need a macro that will change the names of the sheets in a workbook equal to a given cell in those sheets sub userform_initialize() dim x as long For x = 1 to activeworkbook.sheets.count activesheet.name = sheets(x).range("A").value next x end sub -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200605/1 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Sheet Name
Thanks this puts me on the right track. However, for some reason it is
naming the first sheet with data pulled from the third. "Crowbar via OfficeKB.com" wrote: BOONER wrote: I need a macro that will change the names of the sheets in a workbook equal to a given cell in those sheets sub userform_initialize() dim x as long For x = 1 to activeworkbook.sheets.count activesheet.name = sheets(x).range("A").value next x end sub -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200605/1 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Sheet Name
Okay, this works..........Thanks a lot Crowbar
Dim x As Long For x = 3 To ActiveWorkbook.Sheets.Count Sheets(x).Activate ActiveSheet.Name = Sheets(x).Range("I7").Value Next x "BOONER" wrote: Thanks this puts me on the right track. However, for some reason it is naming the first sheet with data pulled from the third. "Crowbar via OfficeKB.com" wrote: BOONER wrote: I need a macro that will change the names of the sheets in a workbook equal to a given cell in those sheets sub userform_initialize() dim x as long For x = 1 to activeworkbook.sheets.count activesheet.name = sheets(x).range("A").value next x end sub -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200605/1 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| excel sheet bootom half sheet goes behind top part of sheet | Excel Worksheet Functions | |||
| Duplicate sheet, autonumber sheet, record data on another sheet | Excel Worksheet Functions | |||
| How do I select price from sheet.b where sheet.a part no = sheet.b | Excel Worksheet Functions | |||
| Copying cells from on sheet to another sheet (via sheet module) | Excel Programming | |||
| Inserting a row in sheet A should Insert a row in sheet B, removing a row in Sheet A should remove the corresponding row in sheet B | Excel Programming | |||
Linear Mode
