Hi Paul,
Thank you very much for your advice and reply.
You are for sure right about regional setting (PC in company has a regional setting USA).
That’s way I’m looking for help in engl. excel forum. Well the macros are created at home on Office 2007 German Version. In the company where I'm working we use Office 2007 engl. Version. And as I know the regional setting are locked on my working PC in the company.
I note that you hadn't declared some variables, including wksZiel, wbZiel and wksQuelle
I am newbie in VBA could you give me please some advice for declaration.
This macro which you have tried I become a help from German excel forum. And at the moment is difficult for the german excel friend to find a mistake cause I have left in this forum my question as open but ther is no reply for this mistake.
That’s way I thought to post this question in one English excel forum.
For any help I am very thankful.
Hans
|