Hi I need to copy and paste the selected worksheets from listbox1 into a new workbook. I have some code so far but don't know where to go from here.
Private Sub CbnSubmit_Click()
Dim i As Integer, j As Integer
Dim a() As Variant
On Error GoTo Errhandler
Application.ScreenUpdating = False
For i = 1 To Me.ListBox1.ListCount
If Me.ListBox1.Selected(i - 1) = True Then
j = j + 1
ReDim Preserve a(j)
a(j) = Worksheets(ListBox1.List(i - 1)).Name
End If
Next
Worksheets(a).Select
Me.Hide
For i = 1 To Me.ListBox1.ListCount
If Me.ListBox1.Selected(i - 1) = True Then
Me.ListBox1.Selected(i - 1) = False
End If
Next
Errhandler:
Worksheets(1).Select
Application.ScreenUpdating = True
Exit Sub
End Sub
PLEASE HELP!!!
Private Sub CbnSubmit_Click()
Dim i As Integer, j As Integer
Dim a() As Variant
On Error GoTo Errhandler
Application.ScreenUpdating = False
For i = 1 To Me.ListBox1.ListCount
If Me.ListBox1.Selected(i - 1) = True Then
j = j + 1
ReDim Preserve a(j)
a(j) = Worksheets(ListBox1.List(i - 1)).Name
End If
Next
Worksheets(a).Select
Me.Hide
For i = 1 To Me.ListBox1.ListCount
If Me.ListBox1.Selected(i - 1) = True Then
Me.ListBox1.Selected(i - 1) = False
End If
Next
Errhandler:
Worksheets(1).Select
Application.ScreenUpdating = True
Exit Sub
End Sub
PLEASE HELP!!!