View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Jos Vens Jos Vens is offline
external usenet poster
 
Posts: 52
Default Cell-format and comparison

Hi,

I just think that the general-format is wrong (see my comparison in the
debugger) and I have to have the format Number (I compare numbers) for the
named cells that I compare. I cannot format everything into numbers.

Jos

"kkknie " schreef in bericht
...
It's because the cells are formatted as text. You may be able to fix it
by just formatting everything as general rather than modifying your
code.

K


---
Message posted from http://www.ExcelForum.com/