It may be because your Windows delimiter is a semicolon instead of a comma, do your Excel formulae look like this
- Code: Select all
=IF(TRUE;TRUE;FALSE)
instead of this
- Code: Select all
=IF(TRUE,TRUE,FALSE)
All of the code relies on comma delimited formula so you may need to change your windows settings to get it working
1. Control Panel
2. Clock, Language and Region
3. Region
4. Additional Settings
5. Numbers tab
6. Ensure "List Separator" is a comma
7. Also Ensure Excel/Options/Advanced has "use system separators" checked
(the alternative option is to change all VBA formula to use a semicolon delimiter)
Os