EXCEL VBA Questions and Answers

Code to find a Last used Row in a column or Last used column of a Row.

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.