Find Numeric and paste on another sheet.

[Tortus]

I didn't know how to give this a proper title to maybe help others..

I have this code and it is working, but in column H there are 2 other charterers besides numeric that are being copied also. (~, --------)

How do I change this code to ignore everything except IsNumeric?

Please Login or Register  to view this content.

Thank you!

[AB33]

Use a replace method in column A (Copied data)

Please Login or Register  to view this content.

[Tortus]

Ok, I was filtering and replacing that way. I was just wondering if excel recognizes those special charterers as numeric?

I'll add your suggested method to my code just to go faster!