Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy paste sheet name
I am trying to Copy the Active worksheet name and paste it into cell AF2.
How can i do this? I need it to added to this code: Sub CommandButton1_Click() With ActiveWorkbook ..Worksheets("1").Copy After:=.Worksheets(.Worksheets.Count) ActiveSheet.Name = Worksheets.Count UserForm1.Hide Dim myFileName As Variant Dim NewWksName As String Dim NewWkbk As Workbook Dim NewWks As Worksheet NewWksName = Worksheets.Count With NewWkbk Set NewWks = Nothing On Error Resume Next Set NewWks = .Worksheets(NewWksName) On Error GoTo 0 End With If NewWks Is Nothing Then End If Call Macro10 [B3].Select ActiveCell = Me.ComboBox1.Value ActiveSheet.Visible = True End With End Sub Can anyone assist me with this ? Regards Corey |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy paste sheet name
Range("AF2").Value = ActiveSheet.Name
HTH Die_Another_Day "Corey" wrote in message ... I am trying to Copy the Active worksheet name and paste it into cell AF2. How can i do this? I need it to added to this code: Sub CommandButton1_Click() With ActiveWorkbook .Worksheets("1").Copy After:=.Worksheets(.Worksheets.Count) ActiveSheet.Name = Worksheets.Count UserForm1.Hide Dim myFileName As Variant Dim NewWksName As String Dim NewWkbk As Workbook Dim NewWks As Worksheet NewWksName = Worksheets.Count With NewWkbk Set NewWks = Nothing On Error Resume Next Set NewWks = .Worksheets(NewWksName) On Error GoTo 0 End With If NewWks Is Nothing Then End If Call Macro10 [B3].Select ActiveCell = Me.ComboBox1.Value ActiveSheet.Visible = True End With End Sub Can anyone assist me with this ? Regards Corey |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy paste sheet name
thanks
-- Regards Corey |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy from one Sheet and paste on another sheet based on condition | Excel Discussion (Misc queries) | |||
Active Cell Copy And Paste Sheet to Sheet | New Users to Excel | |||
Copy and paste from one sheet to many | Excel Programming | |||
Copy, paste to another sheet | Excel Programming | |||
automatic copy and paste from sheet to sheet in a workbook | Excel Programming |