!pro
08-10-2017, 01:50 PM
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
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