Your code assumes that the lowest filled cell in the 5 columns is in column E
and that cell happens to be active. I don't think the OP indicated that either
of those were pre-existing conditions.

On Sun, 21 Nov 2004 09:53:05 -0800, DMoney
wrote:

try this-- activecell.offset(rowoffset:=1,columnoffset:=-4).activate


"David" wrote:

I've seen hundreds of ways to activate the next empty cell in a column, but
I need to activate a cell in column A one row down from the last entry in a
range of cells ("A2:E32") to copy more data into.

The problems I've run into stem from the fact that cells A33:E33 contain
averages of the data in that range, so they are included in any xlUP or
xlDown or UsedRange arguments.

What I want is a single statement as opposed to a cell scan.

--
David