View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Wescotte Wescotte is offline
external usenet poster
 
Posts: 28
Default Runtime Error 6 Overflow

One other thing to note.. The code is designed to take all non numbers
and just empty the contents of the cell but that doesn't seem to
function either..

The If IsNumeric(.Value) = True doesn't ever seem to be false