Syntax Error

[hanif]

Hi All,

Please see attached. I have a workbook created with piece of VBA. I get some errors (syntax error and expected name error) when run the VBA but can't see what is wrong with the code. could you please see the code and let me know how to fix it.

Much appreciated.

[maniacb]

Try this version(not tested)

Please Login or Register  to view this content.

[hanif]

Thanks maniacb, ir still comes up with some errors.

[maniacb]

What are the errors?

[romperstomper]

The Formula/FormulaR1C1 properties expect US formula strings, not German.

[mjr veverka]

... still comes up with some errors ...

Make a new workbook.
You have many 'ThisWorkbook' modules with different names: "DieseArbeitsmappe", "ThisWorkbook", and many, many, many, many, many, many, many, many, many, many .... many x n "Tabelle" (= ThisWorkbook) ... : / ... your file is corrupted.

[hanif]

Thank you very much making a new workbook solved the problem.