View Single Post
  #24   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Harlan Grove[_2_] Harlan Grove[_2_] is offline
external usenet poster
 
Posts: 1,231
Default Countif function for Even and Odd numbers

John C <johnc@stateofdenial wrote...
If a column is set up with error trapping so that it only contains integers,

....

You haven't written many workbooks for other people to use.

Set up whatever data validation rules you want to ENSURE only integers
are valid entries, type (but don't press enter) 0.125, press [F2],
[Shift]+[Home], [Ctrl]+C, [Esc], [Ctrl]+V.

Try to use event handlers - open the workbook with macros disabled.