Skip a value
Closed
prabinkaal
Posts
1
Registration date
Tuesday 19 November 2013
Status
Member
Last seen
19 November 2013
-
19 Nov 2013 à 12:55
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 21 Nov 2013 à 10:50
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 21 Nov 2013 à 10:50
Related:
- Skip a value
- Skip hash check - Guide
- Windows 11 skip welcome screen - Guide
- Vlc skip forward 5 seconds android - Guide
- Skip facebook login - Guide
- Pc call of duty level skip pc cheat - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday 12 September 2010
Status
Contributor
Last seen
27 December 2022
555
21 Nov 2013 à 10:50
21 Nov 2013 à 10:50
Hi Prabinkaal,
I would advise you to use a header and then use the following code for best result:
Best regards,
Trowa
I would advise you to use a header and then use the following code for best result:
Sub RunMe()
Dim lRow As Integer
lRow = Range("B1").End(xlDown).Row
For Each cell In Range("B2:B" & lRow)
If cell = 10 Then cell.Offset(0, -1).Copy _
Range("G" & Rows.Count).End(xlUp).Offset(1, 0)
Next cell
End Sub
Best regards,
Trowa
