Sub DropList()
' Dim myRow As Integer
' Dim myHeight As Integer
' myRow = 5
Dim copyrows As Integer
Dim tWb As Workbook
' copyrows = 21 'data source rows'词句相当于给行数为21
' myHeight = copyRows + 3 - myRow '3 is the difference of B5 to first data row
Set tWb = ThisWorkbook
copyrows = tWb.Sheets("Filter").Range("a1").End(xlDown).Row