For version:
For the active regional settings
For insertion of formulae etc remember that VBA is US-centric by default so unless you're using FormulaLocal (as opposed to standard Formula) you should find you can code all of those parts in US form (incl. delimiters) without worrying about client settings (they will auto translate when written to the worksheet).
(note: exceptions would be things like month denotations in TEXT function calls etc which would need to be adjusted)
EDIT: the above point may not hold true on a non-English install - so apologies if misleading.
Bookmarks