Hi all,

I want to copy the dynamic Range ("A6:C6+b,F6:BS6+b") with code.

Dim GFE As Worksheets
Dim b As Long
    
Set GFE = ThisWorkbook.Sheets("GFE+")
b = Application.WorksheetFunction.CountIf(Range("GFE_Material"), "?*") - 3

GFE.Range(GFE.Cells(6, 1), GFE.Cells(6, 2).Offset(b, 0), GFE.Cells(6, 6), GFE.Cells(6, 71).Offset(b, 0)).Copy
There's seems to be a syntax/with variable error... Can someone help?