View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Claus Busch Claus Busch is offline
external usenet poster
 
Posts: 3,872
Default Format change with VBA language dependent?

Hi,

Am Tue, 19 Nov 2013 12:13:46 -0800 (PST) schrieb tskogstrom:

Range(rng).NumberFormat = "General"

"General" is a string and I guess it is called something else in other languages. At least in the user GUI's


VBA "speaks" English in all language versions of Excel.
You only run into problems using Formula.Local
If your workbook should be opened in other language versions than yours
use Formula.


Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2