Tuesday, 15 March 2011

Formulas within Named Range changes when opened in foreign langauge version of Excel -


The following definition works well for the named category when opened in an English language version of Excel: = OFFSET ('summary data'! $ B $ 9,0,0, total stop + 1, summary data column)

However, when the same worksheet ( English language is a version of Excel) Excel's Portugues is open using the Langes version, the formula has been changed in the designated category Is: 

  = DESLOC ('summary data'! $ B $ 9; 0; 0; total stop +1; summary data column)   
 my understanding The correct translation is for "office", but all the commas in the formula have been replaced with the semi-colon. At any time the designated category is sent to the VBA code, code execution fails at that time.  
 Just for reference, the reference to the named range is of that form:  
  
 Any ideas?   
 
 this workbook "Text"> 
 This link can provide better explanation,  
 You should be able to do a check on what language has been selected in your VBA code and if other than English Re-execute the colon for this semi-coma.   

 








Posted by



at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)