Quote Originally Posted by Glissege View Post
If i set my language and settings to US it will work. Unfortuanly the people i sent this document too only have the dutch excel.

I have a second question, when i input some numbers and press enter, the selection goes straight to the subval. What is the reason for this and can we change it?
As written, the code uses .NavigateArrows and ActiveCell to determine the precedents of a cell. Since then, I've learned that the ActiveCell is not needed, so that could be re-written and (hopefuly) the second issue will be addressed.