Hello. Here is a code snippet and I'm getting a mf error. Why? It says object doesn't support this property or method when it gets to the .offset part.
![]()
With Sheets(s + 1).Range("A1").CurrentRegion .Offset(1, 2).Resize(Rows.Count - 1, Columns.Count - 2).Formulas = "=SUMIFS(Master!$D$2:$D$5,Master!$C$2:$C$5,'101'!$B2,Master!$B$2:$B$5,'101'!C$1)" End With Next cell
Bookmarks