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
- Delete my whatsapp account without app - Guide
- How to delete whatsapp account without phone - Guide
- Delete snapchat account permanently - Guide
- How to delete icloud tabs - Guide
- How to delete part of a table in word - 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
