Find Lowest Column Among Several
Say I've got the line
Set objProduction = objCurrent.Worksheets("ACCOUNTS").Range("A4:F600") in code. On the worksheet "ACCOUNTS", the last entry by the user might be in row 23. However, it may be in column A, or column C, or column E. Is there any way for Excel to detect that, among those 8 columns, the lowest used row is 23, and then resize the range? -- Hmm...they have the Internet on COMPUTERS now! |
All times are GMT +1. The time now is 04:35 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com