Problem on identifying last row using excel VBA

[astral007]

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?

is there a problem with code?

 

[JackDanIce]

Welcome to the board.

You're using SpecialCells(xlCellTypeVisible) - have you applied a filter so are only selecting the cells visible on the sheet after filter is applied (which doesn't include the last row), i.e. the last row is filtered out?

What is the name of the activesheet? You may want to post your entire code.

 

[astral007]

Welcome to the board.

You're using SpecialCells(xlCellTypeVisible) - have you applied a filter so are only selecting the cells visible on the sheet after filter is applied (which doesn't include the last row), i.e. the last row is filtered out?

What is the name of the activesheet? You may want to post your entire code.

problem solved! :D id just deleted blank column in my worksheet ...
thank you :D