Skip a value
Closed
prabinkaal
Posts
1
Registration date
Tuesday November 19, 2013
Status
Member
Last seen
November 19, 2013
-
Nov 19, 2013 at 12:55 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Nov 21, 2013 at 10:50 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Nov 21, 2013 at 10:50 AM
Related:
- Skip a value
- Skip torrent - Guide
- Windows 10 skip welcome screen - Guide
- Skip redirect opera - Guide
- Vlc skip to next video - Guide
- Facebook skip login - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
Nov 21, 2013 at 10:50 AM
Nov 21, 2013 at 10:50 AM
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
