Try resize instead
VBA Noob![]()
Dim Tblrows As Long Dim i As Long Tblrows = 100 For i = 2 To Tblrows With Range("b" & i) If .Value = "1" Then .Offset(0, 1).Resize(1, 5).Copy End If End With Next i Application.CutCopyMode = False
Try resize instead
VBA Noob![]()
Dim Tblrows As Long Dim i As Long Tblrows = 100 For i = 2 To Tblrows With Range("b" & i) If .Value = "1" Then .Offset(0, 1).Resize(1, 5).Copy End If End With Next i Application.CutCopyMode = False
_________________________________________
![]()
![]()
Credo Elvem ipsum etian vivere
_________________________________________
A message for cross posters
Please remember to wrap code.
Forum Rules
Please add to your signature if you found this link helpful. Excel links !!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks