Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
rename sheet
Hi. If I copy a sheet to a new workbook, how can I rename that sheet with a
left function? For example, the sheet I copied from book1 was called "sheet1of_the_workbook". In excel terms, I want to rename the sheet Left(that sheet name,5). Thanks! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
rename sheet
Dim sStr as String
sStr = "sheet1of_the_workbook" worksheets(sStr).Name = Left(sStr,5) -- Regards, Tom Ogilvy "Steph" wrote in message ... Hi. If I copy a sheet to a new workbook, how can I rename that sheet with a left function? For example, the sheet I copied from book1 was called "sheet1of_the_workbook". In excel terms, I want to rename the sheet Left(that sheet name,5). Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i rename a sheet if the rename tab is inactive? | Excel Worksheet Functions | |||
macro to: Add new sheet, then rename new sheet with todays date | Excel Worksheet Functions | |||
Move data to new sheet - rename sheet based on criteria ? | Excel Discussion (Misc queries) | |||
Rename a sheet | Excel Programming | |||
Button to copy sheet, rename sheet sequencially. | Excel Programming |