Do follow us for more learning’s Fb,G+,Twitter.
Using UsedRange property:-
This approach is frequently implemented and one of our favorite. But sometime we have seen that incase some formatting is present in the sheet, it points till the last range of the excel (like 1,048,576 rows in excel -2013) itself rather than the last occupied row of the sheet.
- Using “CTRL+SHIFT+END” to find the last row
- Using “CTRL+SHIFT+Down Arrow” to find the last row
- Using “CTRL+SHIFT+left/Right arrow” to find the last column