Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy a sheet and rename it
Can someone please show me what I am stupidly missing:
I want to make a copy of a very hidden sheet named LogTemplate and position it after the sheet named LOG (visible). Rename the copy as Log Future # where # is the next number in sequence. So if Log Future 1 already exists, name the new one Log Future 2, and so on... I won't post my code (unless someone requests it) since it is useless any way. Thanks much in advance for your assistance. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy a sheet and rename it
try unhiding the sheet.
copy it rename it then hide it again or is that what you are needing help with? "quartz" wrote: Can someone please show me what I am stupidly missing: I want to make a copy of a very hidden sheet named LogTemplate and position it after the sheet named LOG (visible). Rename the copy as Log Future # where # is the next number in sequence. So if Log Future 1 already exists, name the new one Log Future 2, and so on... I won't post my code (unless someone requests it) since it is useless any way. Thanks much in advance for your assistance. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy a sheet and rename it
Really? I didn't think you needed to unhide the sheet to copy it...
"ben" wrote: try unhiding the sheet. copy it rename it then hide it again or is that what you are needing help with? "quartz" wrote: Can someone please show me what I am stupidly missing: I want to make a copy of a very hidden sheet named LogTemplate and position it after the sheet named LOG (visible). Rename the copy as Log Future # where # is the next number in sequence. So if Log Future 1 already exists, name the new one Log Future 2, and so on... I won't post my code (unless someone requests it) since it is useless any way. Thanks much in advance for your assistance. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy a sheet and rename it
You are right...it worked as you said. Thanks.
"quartz" wrote: Really? I didn't think you needed to unhide the sheet to copy it... "ben" wrote: try unhiding the sheet. copy it rename it then hide it again or is that what you are needing help with? "quartz" wrote: Can someone please show me what I am stupidly missing: I want to make a copy of a very hidden sheet named LogTemplate and position it after the sheet named LOG (visible). Rename the copy as Log Future # where # is the next number in sequence. So if Log Future 1 already exists, name the new one Log Future 2, and so on... I won't post my code (unless someone requests it) since it is useless any way. Thanks much in advance for your assistance. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy a sheet and rename it
Dim i As Long
Dim sh As Worksheet i = 0 On Error Resume Next Do Set sh = Nothing i = i + 1 Set sh = Worksheets("Log Future " & i) Loop Until sh Is Nothing On Error GoTo 0 Worksheets("Sheet2").Copy after:=Worksheets("Log") ActiveSheet.name = "Log Future " & i -- HTH RP (remove nothere from the email address if mailing direct) "quartz" wrote in message ... Can someone please show me what I am stupidly missing: I want to make a copy of a very hidden sheet named LogTemplate and position it after the sheet named LOG (visible). Rename the copy as Log Future # where # is the next number in sequence. So if Log Future 1 already exists, name the new one Log Future 2, and so on... I won't post my code (unless someone requests it) since it is useless any way. Thanks much in advance for your assistance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
keyboard shortcut to pull up sheet menu(copy,delete,rename,etc)? | Excel Discussion (Misc queries) | |||
Copy worksheet and rename sheet | Excel Discussion (Misc queries) | |||
Macro REQ: Automatically copy a template sheet and rename | Excel Worksheet Functions | |||
Copy/Rename a sheet | Links and Linking in Excel | |||
copy Sheet and rename it! | Excel Programming |