The following definition works well for the named category when opened in an English language version of Excel: 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: 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 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. = OFFSET ('summary data'! $ B $ 9,0,0, total stop + 1, summary data column)
= DESLOC ('summary data'! $ B $ 9; 0; 0; total stop +1; summary data column)
No comments:
Post a Comment