Sorry Tom, your right . I was getting confused. It's working great now.
Many thanks
--
ASU


"Tom Ogilvy" wrote:

You said you wanted to run the code when you edited the last row - and the
sample code restriced that action to column 1. So the code I posted only
runs when you hit enter after editing the cell in column 1 of the last row.
Then it copies formulas to the cells below that. Where the selection ends
up depends on your move after return setting or where you click with the
mouse. The code does not alter the behavior that would have occured if the
code did not run.

If this doesn't do what you want, then perhaps a very clear explanation of
exactly what you want to happen based on the users action specifically in
what location would provide a better response. For example, the code you
posted fires when the user selects a cell, but you asked for something to
happen when a cell is changed. This would say to change the selectionchange
event to the change event. A so forth based on what you described.

--
Regards,
Tom Ogilvy

"ASU" wrote in message
...
Basically what Im after is to run that code automatically so that the row
is
pasted without having to manually select the next cell?
--
ASU


"ASU" wrote:

Thanks very much Tom. But when the code runs to the end, it laeves the
slected cell two rows up. How can I have it to end with the next empty
cell
selected.
--
ASU


"Don Guillett" wrote:

toolsoptionseditmove

--
Don Guillett
SalesAid Software

"ASU" wrote in message
...
How do I automatically select the next empty cell, in column "A",
when
data
has been inserted.
--
ASU