InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
Code To Find A Last Used Row In A Column Or Last Used Column Of A Row. |
|
Answer» Last ROW in a COLUMN can be find USING End(xlUp) and Last Column in a row can be find using End(xlToLeft). For e.g. Range("A1048576").End(xlUp).Row GIVES last USED row of Column A. Last Row in a column can be find using End(xlUp) and Last Column in a row can be find using End(xlToLeft). For e.g. Range("A1048576").End(xlUp).Row gives last used row of Column A. |
|