Hi at all,

I got a lil problem.
Can somebody explain to me whats the differend between ..

AnZ = Cells(Rows.Count, 1).End(xlUp).Row ' shows a MsgBox with "3" cause Mappe1 : Hello (1,1) Hello (1,2) Hello(3,1)
and
Anz = UsedRange.Rows.Count ' aint work

By the way , why would this not work...
AnZ = Mappe1.Cells(Rows.Count, 1).End(xlUp).Row

' Mappe1 is declared Dim Mappe1 As Workbook
Set Mappe1 = ThisWorkbook

Im new in VBA , excuse my english im from Germany