Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find the lowest number in a given column | Excel Worksheet Functions | |||
Find the 10 lowest of 20 numbers in column and enter those 10 in a | Excel Worksheet Functions | |||
Find Lowest Column Among Several | Excel Programming | |||
Find Lowest Column Among Several | Excel Programming | |||
Find Lowest Column Among Several | Excel Programming |