hi all,

good days.


how to get the last used of row for the range of data (A:W).
if i had draw border to row 300.


'LastRow = Cells(Rows.Count, 1).End(xlUp).Row (this 1 is only can count one column only)
''LastRow = ActiveSheet.UsedRange.Rows.Count (this 1 get the lastrow = 300 because i draw the border even there is blank)


i want to count the last used of row for the range of data which exclude the border i draw to 300

hope can get help from your all.

thank you~