How to delete cells with decimal numbers?

Please, I did a search:
http://www.excelforum.com/excel-prog...-integers.html

and found this code from JBeaucaire:

Please Login or Register  to view this content.

The forum rules say I must start a new thread.

I've tried and that code works.

But I have a simple question:
making a small change in this code, how to delete just the cells with decimal values, not the entire row?

My very humble experience with VBA isn't enough to adjust this.

Hi,

Try:

Please Login or Register  to view this content.

Just remove the "EntireRow" from the code.

You could try something like this, but you will have to decide what level of sensitivity you are willing to accept.

Please Login or Register  to view this content.

Greg

Originally Posted by dualaudio454252

how to delete just the cells with decimal values, not the entire row?

Perhaps some clarification is needed on this point. When you say "delete", do you mean delete as in you will have to either shift everything up or right or left (probably not what you want). Or, do you mean to just set the cell's value to null (or blank)?

Originally Posted by dualaudio454252

Fantastic, gsnidow! That's it!

Thank you so much to you all!!!!!!

Now you need to be carefull with that. Eventhough you might see, say, 12, in any given cell, the value that Excel is storing might be 12.000001, or something else like that. If you play around with it by increasing the number of decimal places you are willing to accept, you will see what I mean. Good luck.