R
radio848
a few days ago, someone provided me with this macro:
Sub SM()
Application.ScreenUpdating = False
Dim CurrentSheet As String
CurrentSheet = Application.ActiveSheet.Name
Sheets(CurrentSheet).Copy After:=Sheets(CurrentSheet)
End Sub
it works fine. copies the sheet and everything. but, what do i add and
where, to clear the macro in the copied page after it has done its job.
in other words, to be active in the first sheet, (control) if you will
sheet.
help!
Thanks
Sub SM()
Application.ScreenUpdating = False
Dim CurrentSheet As String
CurrentSheet = Application.ActiveSheet.Name
Sheets(CurrentSheet).Copy After:=Sheets(CurrentSheet)
End Sub
it works fine. copies the sheet and everything. but, what do i add and
where, to clear the macro in the copied page after it has done its job.
in other words, to be active in the first sheet, (control) if you will
sheet.
help!
Thanks