Was mach ich bitte im untenstehenden Code falsch, da ich immer eine Fehlermeldung erhalte.
mobtxt3 ist eine Textbox und in diese möchte ich die Summenzahl der Spalten B,G,L;Q;V;AA;AF reinbekommen.(von jeweils 2 bis 249)
Danke
Josef
mobetxt3 = Application.WorksheetFunction.SumIf(ActiveWorkbook.ActiveSheet.Range("a2:a249"), Name1, ActiveWorkbook.ActiveSheet.Range("B2:B249")) + _
Application.WorksheetFunction.SumIf(ActiveWorkbook.ActiveSheet.Range("a2:a249"), Name1, ActiveWorkbook.ActiveSheet.Range("G2:G249")) + _
Application.WorksheetFunction.SumIf(ActiveWorkbook.ActiveSheet.Range("a2:a249"), Name1, ActiveWorkbook.ActiveSheet.Range("L2:L249")) + _
Application.WorksheetFunction.SumIf(ActiveWorkbook.ActiveSheet.Range("a2:a249"), Name1, ActiveWorkbook.ActiveSheet.Range("Q2:Q249")) + _
Application.WorksheetFunction.SumIf(ActiveWorkbook.ActiveSheet.Range("a2:a249"), Name1, ActiveWorkbook.ActiveSheet.Range("V2:V249")) + _
Application.WorksheetFunction.SumIf(ActiveWorkbook.ActiveSheet.Range("a2:a249"), Name1, ActiveWorkbook.ActiveSheet.Range("AA2AA249")) + _
Application.WorksheetFunction.SumIf(ActiveWorkbook.ActiveSheet.Range("a2:a249"), Name1, ActiveWorkbook.ActiveSheet.Range("AF2:AF249"))