W
walker002
hello to everything,
I must work with two Excel maps, because several users should acces
the data.
If the second map is opened, I am able to come:
Workbooks(Mappe2).Worksheets("Tabelle1").ActiveSheet.UsedRange.Rows.Coun
… The number of the lines determine. Thus a connection with the secon
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, als
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 n
error message comes and I have the desired access?
I would be really grateful for help
walke
I must work with two Excel maps, because several users should acces
the data.
If the second map is opened, I am able to come:
Workbooks(Mappe2).Worksheets("Tabelle1").ActiveSheet.UsedRange.Rows.Coun
… The number of the lines determine. Thus a connection with the secon
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, als
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 n
error message comes and I have the desired access?
I would be really grateful for help
walke