Uma Possibilidade,
no codigo de exclusão altere para
Sub Excluir()
Dim wsCadastro As Worksheet, wsSaida As Worksheet
Set wsCadastro = ThisWorkbook.Sheets("Produtos")
Set wsSaida = ThisWorkbook.Sheets("saida")
Application.ScreenUpdating = False
wsCadastro.Activate
With wsCadastro
.Range("a2").Select
For cont = 1 To .Cells(Rows.Count, "a").End(xlUp).Row
If ActiveCell = TextBox1.Text Then
ActiveCell.EntireRow.Delete
End If
ActiveCell.Offset(1, 0).Activate
Next
.Range("a2").Select
End With
wsSaida.Activate
With wsSaida
.Range("a2").Select
For cont = 1 To .Cells(Rows.Count, "a").End(xlUp).Row
If ActiveCell = TextBox1.Text Then
ActiveCell.EntireRow.Delete
End If
ActiveCell.Offset(1, 0).Activate
Next
.Range("a2").Select
End With
MsgBox "Registro Excluído!"
Application.ScreenUpdating = True
End Sub
Existem mil maneiras de preparar Neston. Invente a sua!
http://www.youtube.com/ExpressoExcel
Postado : 07/09/2012 12:16 pm