Code for Selecting and Deleting Certain Value

[Grabaka]

Hey,


I have a spreadsheet with over 14,000 entries and I am trying to eliminate some of the data in it to make it more manageable. Two pieces of data that I would like to eliminate is a twelve digit number (e.g. 000004469544) and the other are decimal numbers (e.g. 1.00 or 12.00). Any suggestions on how what the macro code would look like?

[mehmetcik]

Hi

This code will delete all rows with a numeric value in column A

Its a start. I need to know more before I spend more time on this.

Please Login or Register  to view this content.

[shyamhappy]

Please Login or Register  to view this content.

Here the above code will consider the A column as text and check for the length of string and checks for is there any decimal point in the cell.

If present, then removes entire row.

_____________________________________________________________________________________________________________________________________
Please click * to say thank you

[Grabaka]

Thank you very much. I greatly appreciate your help.