copy the row where a cell contains a numeric value

[shaz0503]

Hi all

I have a macro that I am trying to modify - of which I am sure is quiet easy - but I'm have a mental block....

The code I have copies rows of data where there cell value does not start with a numeric value. I am trying to modify this code to copy the row where a cell contains a numeric value (cell should be alpha character only)....

Please see attached workbook....

I am toying with macros to identify errors with large data set.....

Any assistance appreciated....

rgds

shaz0503

[:) Sixthsense :)]

Numeric Values in the beginning or entire numeric values?

Which macro code you are talking about since your file consist two codes

[shaz0503]

sixthsense

The CopyAddressError works fine

I was trying to get CopyNameError to work correctly (this is the code I need)

You will see in "Data" that cell D4 has a number after Black..... this is the row I want copied to a new sheet.....

rgds

[:) Sixthsense :)]

Just add an asterisk in the beginning too..

Please Login or Register  to view this content.

[shaz0503]

thanks SixthSense - works a treat

[:) Sixthsense :)]

Glad it helps you and thanks for the feedback