admiral_pelican
New Member
- Joined
- Jan 18, 2019
- Messages
- 4
Hello,
Can someone take a look at this bad boy and tell me why I'm getting a 400 error?
Please assist.
Sub Macro1()
Dim Rang1 As Range
Set Rang1 = Range("A1")
Dim Row1 As Integer
Row1 = ActiveCell.Row
Dim Sumact As Long
Sumact = Appplication.SumIfs(Worksheets("ERM ").Range("G:G"), Worksheets("ERM ").Range("K:K"), "1", Worksheets("ERM ").Range("B:B"), Rang1.Offset(0, Row1))
MsgBox Sumact
End Sub
Can someone take a look at this bad boy and tell me why I'm getting a 400 error?
Please assist.
Sub Macro1()
Dim Rang1 As Range
Set Rang1 = Range("A1")
Dim Row1 As Integer
Row1 = ActiveCell.Row
Dim Sumact As Long
Sumact = Appplication.SumIfs(Worksheets("ERM ").Range("G:G"), Worksheets("ERM ").Range("K:K"), "1", Worksheets("ERM ").Range("B:B"), Rang1.Offset(0, Row1))
MsgBox Sumact
End Sub