Hi all,
I want to copy the dynamic Range ("A6:C6+b,F6:BS6+b") with code.
There's seems to be a syntax/with variable error...![]()
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
Can someone help?
Bookmarks