Olhei o codigo e ele so faz o a consulta do estoque se em A3 tiver Todos.
Vc precisa alterar o valor para uma variavel.
Teste assim
Public Sub lsConsultaEstoque()
Dim Cons As String
Cons = Range("A3").Value
Sheets("Consulta Estoque").Unprotect
Application.ScreenUpdating = False
Worksheets("Consulta Estoque").Rows("10:500000").Delete
If Cons <> "" Then
Plan4.Range("A1:L" & WorksheetFunction.CountA(Plan4.Columns(1)) + 1).Copy (Plan1.Cells(8, 1))
Else
Plan4.Range("$A$1:$A$" & WorksheetFunction.CountA(Plan4.Columns(1))).AutoFilter Field:=1, Criteria1:=Plan1.Cells(3, 1)
Plan4.Range("A1:L" & WorksheetFunction.CountA(Plan4.Columns(1)) + 1).Copy (Plan1.Cells(8, 1))
Plan4.Range("$A$1:$A$" & WorksheetFunction.CountA(Plan4.Columns(1))).AutoFilter
End If
lsRedimensionarTabela
Application.ScreenUpdating = True
Sheets("Consulta Estoque").Protect
End Sub
Substitua a macro de consulta por esta.
Postado : 13/12/2015 10:39 am