UL is a variant, not dates. Numbers.


"Thomas Ramel" wrote in message
...
Grüezi Bill

Bill schrieb am 08.02.2006

I want to find the number of values in a database greater than a certain
value UL. The following code works in the United States Regional Option:

If UL < "" Then NumOOS = Application.CountIf(Database, "" & UL & "")

But it always gives 0 in, for example, the regional option for Germany.

I'm from Switzerland and used to Regional Optin issues, because our
Options
are not quite teh same as the German ones....


How ist 'UL' declared?
Whats it's value?

Whats the content of your database?

I suspect these are dates?



Regards
Thomas Ramel (@work)

--
- MVP for Microsoft-Excel -
[Win XP Pro SP-2 / xl2000 SP-3]
Microsoft Excel - Die ExpertenTipps:
(http://tinyurl.com/9ov3l und http://tinyurl.com/cmned)