Assuming you have no completely blank rows or columns within your data, how
about

Set objProduction = _
objCurrent.Worksheets("ACCOUNTS").Range("A4").Curr entRegion

On Fri, 17 Sep 2004 12:01:01 -0700, MDW wrote:

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?