Delete Values That Are Not Whole Numbers

  • I'm looking for a way, inside a Macro, to delete any value in a range of cells that is not a whole number.

    Say I have a range from "A4:C50" I am pasting items from another sheet through a Macro Button but I want code at the end of the Macro to then delete anything in this range that is not a whole number.


  • Re: Delete Value In Cell In Not Numerical Value

    Try this. This code works on the selected cells. You can change the For Each Cl In Selection.Cells line to point to any range of cells you'd like

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!