View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ryan H Ryan H is offline
external usenet poster
 
Posts: 489
Default Find all cell with a decimal value

What do you want to do with the cells? Do you want to put them into an
Array, a Collection, highlight the cells, list the cell addresses in another
worksheet?
--
Cheers,
Ryan


"Steven" wrote:

I am in a blank sheet in a worksheet.

Is there a way to return all the cells within the worksheet that have a
value behind the decimal? For example: 1,245.00 would not be returned
because it is 0 after the decimal but 1,245.01 would be returned. I am only
looking for this to 2 decimal places.

Thank you,

Steven