The question doesn't make sense, by definition the first empty row on a new
sheet will always be row-1 (and the first empty column also 1 not that you
specified which column you want to paste to).

In addition to clarifying the above confirm the named range "apples" is a
workbook level name that you have already defined, and that the range refers
to a single area (or otherwise).

Regards,
Peter T


"J.W. Aldridge" wrote in message
...
For each new sheet created (workbook code), paste named range "apples"
at the next available/empty row in column A.