Hi, Im just newbie in excel VBA :)
ActiveSheet.Range("A6:K" & Sheets("Sheet2").Cells(Rows.Count, 1).End(xlUp).Row).SpecialCells(xlCellTypeVisible).Select
using the code above its only selected 1,528 rows where it supposedly selected 2,092 rows which is my last row?:confused:
is there a...