European vs English Issue
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 |
European vs English Issue
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) |
European vs English Issue
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 |
European vs English Issue
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) |
European vs English Issue
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) |
All times are GMT +1. The time now is 10:38 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com