How to convert Index(match.. (Left(Right...)..)..) into VBA (excel)

[Paul_Hossler]

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?

[Alternsti]

1. Define 'always stopping' -- is there an error message or something?
the macro stop at this line and was hightlighted in yellow into Developer tab.

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
Latest_Range, LatestLineNo are both array name (I assume that's the way to put those into VBA code

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

I've made some change into my post to show what is used as range names.

Thanks for your help!