i use the following to find the last row in column A.
If I have columns A thru X and each column can have a different number of rows in use, can the above statement be modified to find the row count for the longest column? Or do I have to look at each column separately? Thanks.
Code:
lbrowCNT = Range("A1", Range("A" & Rows.Count).End(xlUp)).Rows.Count