Delete #N/A
Closed
Andy
-
May 16, 2011 at 09:32 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - May 17, 2011 at 02:01 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - May 17, 2011 at 02:01 AM
Related:
- Delete #N/A
- How to delete whatsapp account without login - Guide
- How to delete whatsapp account without phone - Guide
- Delete snapchat - Guide
- Yahoo search history delete - Guide
- How to delete tabs on android - Guide
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
May 17, 2011 at 02:01 AM
May 17, 2011 at 02:01 AM
try this (not checked)
Do Until IsEmpty(i.Range("Q" & j))
If i.Range("Q" & j) = "TERM" Then
d = d + 1
e.Rows(d).Value = i.Rows(j).Value
Else
e.Rows(d).Value ""
End If
