Adonias
05-06-2020 22:43:57
Pessoal, alguém pode me ajudar com esse código? Está apresentado erro de Execução apontando para tipos incompatíveis.
Private Sub CommandButton1_Click()
Dim i As Integer
Dim myvar As variant
Dim myrng As Range
Dim myrng2 As Range
Dim myrng3 As Range
Dim myrng4 As Range
Dim myrng5 As Range
Dim myrng6 As Range
Set myrng = Sheets("CasaPio").Range("G5:G20")
Set myrng2 = Sheets("CasaPio").Range("M5:M20")
Set myrng3 = Sheets("CasaPio").Range("N5:N20")
Set myrng4 = Sheets("CasaPio").Range("H5:H20")
Set myrng5 = Sheets("Tarefa").Range("B12:B22")
Set myrng6 = Sheets("Tarefa").Range("D11")
For i = 5 To 20
myvar = Application.WorksheetFunction.CountIfs(myrng, "Masc" & myrng4, "myrng5" & myrng2, "2014", myrng3, "myrng6")
Next
MsgBox myvar
End Sub
Private Sub CommandButton1_Click()
Dim i As Integer
Dim myvar As variant
Dim myrng As Range
Dim myrng2 As Range
Dim myrng3 As Range
Dim myrng4 As Range
Dim myrng5 As Range
Dim myrng6 As Range
Set myrng = Sheets("CasaPio").Range("G5:G20")
Set myrng2 = Sheets("CasaPio").Range("M5:M20")
Set myrng3 = Sheets("CasaPio").Range("N5:N20")
Set myrng4 = Sheets("CasaPio").Range("H5:H20")
Set myrng5 = Sheets("Tarefa").Range("B12:B22")
Set myrng6 = Sheets("Tarefa").Range("D11")
For i = 5 To 20
myvar = Application.WorksheetFunction.CountIfs(myrng, "Masc" & myrng4, "myrng5" & myrng2, "2014", myrng3, "myrng6")
Next
MsgBox myvar
End Sub