View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jeff Jeff is offline
external usenet poster
 
Posts: 921
Default Automated deletion of decimals

Please help:

I need to delete all values that contain decimals from a worksheet, in one
fell swoop, if possible. For instance, the range I am currently working with
is Range("F7:IV2772").

I have whole numbers in many of the cells, and I only want those to remain.

Thank you so much, in advance, for your priceless help!!!


All the best,

Jeff