at the top of your procedure

set cell = ActiveCell

then when you want to return
application.Goto cell, true

would be the best guess.

--
Regards,
Tom Ogilvy


"geebee" wrote:

HI,

I would like to know how to write the code that goes back to the last
"dirtied" cell (i.e. the cell which I last typed data in before performing
VBA to copy in a cell at the top of the worksheet).

Thanks in advance,
geebee