hiii, i have a code something like this :
Public Sub Match()
ThisWorkbook.Sheets("Sheet1").Activate
Range("Data!H8") = Application.Sum(Application.Index(Range("A:GH"), 0, Application.Match("ORDERS" & "Country", Range("B2:B100") & Range("A2:GH2"), 0)))
End Sub
When i run this code i'm getting a error "Type Mismatch", can anybody help me with this, Thankss
Public Sub Match()
ThisWorkbook.Sheets("Sheet1").Activate
Range("Data!H8") = Application.Sum(Application.Index(Range("A:GH"), 0, Application.Match("ORDERS" & "Country", Range("B2:B100") & Range("A2:GH2"), 0)))
End Sub
When i run this code i'm getting a error "Type Mismatch", can anybody help me with this, Thankss