select last dirtied cell

[Guest]

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

 

[Bob Phillips]

If you don't do any selecting in your code, won't it still be active?

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[Guest]

at the top of your procedure

set cell = ActiveCell

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

would be the best guess.

 

[stevebriz]

here is an idea for you.

Sub test()
dirty_cell = ActiveCell.Address

'then
' do stuff here
'at the end of your macro

Range(dirty_cell).Select
End Sub