Deleting Integers

[Relic]

Hi,

I'm quite new to VB, I did a bit a while ago and need to use it again.

I have a vlookup that looks up for duplicates so it either returns a #n/a or a number. From this list i want it to delete any number that has been returned, leaving all the #n/a's (as they aren't duplicates)

I tried a basic For Loop but it removed everything that wasn't a negative integer

Please Login or Register  to view this content.

And i have found it generally crashes when it comes to #n/a (the hash maybe?)

I have played around with no luck so was wondering if anyone could help. My attempt being(the gist of it): IF #n/a THEN leave, ELSE delete.

Many Thanks

Relic

[royUK]

Try

Please Login or Register  to view this content.

[MickG]

Hi Or perhaps

Please Login or Register  to view this content.

Mick

[Relic]

Cheers Roy that works perfectly.