hi,
i want to show last blank row without activate and selecting it
like, this code is selecting last blank row of COlumn(K)
like, this code is activating last blank row of COlumn(K)Sub Last_row_activate_find() Range("K500").End(xlUp).Select End Sub
thank youSub Last_row_activate_find() Range("K500").End(xlUp).Activate End Sub
Bookmarks