hello to everything,

I must work with two Excel maps, because several users should access the data.
If the second map is opened, I am able to come:
Workbooks(Mappe2).Worksheets("Tabelle1").ActiveSheet.UsedRange.Rows.Count
… The number of the lines determine. Thus a connection with the second map and the "Tabelle1" or already, nevertheless, exists?

Why I am able to come then:
Workbooks(Mappe1).Worksheets("Tabelle1").Range(datRange2) = Workbooks(Mappe2).Worksheets("Tabelle1").Range(datRange2).Value
Not the data of the second map in the other copy?!
It appears with me always the error message:
“ Term mistake '9': Index beyond the valid area “
Why???

In the first map the "Tabelle1" is selected, I have this with:
Set shtSheets = ActiveWorkbook.Windows(1).SelectedSheets
For Each wksWorksheet In shtSheets
vbResult = MsgBox(wksWorksheet.Name, vbOKOnly)
Debug.Print wkbWorkbook.Name
Next wksWorksheet

… Checks and it also came as an announcement the "Tabelle1"!

And I can access the "Tabelle1" in the second map, nevertheless, also already (because of Rows. Count).
Thus what do I still make wrong?!
How can I so select the maps and/or tables and/or activate that no error message comes and I have the desired access?

I would be really grateful for help
walker