1. Define 'always stopping' -- is there an error message or something?

2. GUESSING - since it seems you use semicolons (probably based on the Excel language) in the WS formula, do you also need to use them in the VBA statement? I don't know

3. Can you attach a small sample workbook with the named ranges, some data, and the desired result?