Hello,
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.

Any ideas why?

Thanks,

Bill

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)

Maybe try

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


--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Bill" wrote in message
link.net...
Hello,
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.

Any ideas why?

Thanks,

Bill

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)

Grüezi Bill

Bill schrieb am 08.02.2006

UL is a variant, not dates. Numbers.

Hmmm, quite less information....

Maybe an issue with the decimal-separator which is a comma in german
environnements (not in Switzerlad :-)).

Maybe some values of the database are in text-format?


Sorry, without closer informations its not easy to help you.

Maybe it's possible to send the file to my place?


Regards
Thomas Ramel

--
- 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)