VBA Code to Return to last modified Cell.

[nasrulla]

Hi guys,

Need your help. I have a sheet with advance filter. when i enter criteria and enter i want the cell return back to last active cell.
consider, A1:b5 is the criteria. b1:b5 the range i enter the data and hit enter.
For example i select B2 and type by criteria and hit enter (or clicke another cell),it will go to b3.
I want excel to go back to B2.

I try offset "ActiveCell.Offset(-1, 0).Select"

When cell selection is a2 excell cant go up further and give an error (application defined error).

Please help.

[mehmetcik]

Display the Excel Options dialog box.

Select File and then Options.

At the left of the dialog box click Advanced
Make sure the "After Pressing Enter Move Selection" check box is NOT selected.
Click OK.

[nasrulla]

Thank you very much for fast reply. it solved my issue.

I wonder, can it be done by a code.

Will it effect my other workbooks (changing the advance option).

Thank you again.

[jolivanes]

At the beginning of the code, use

Please Login or Register  to view this content.

and at the end set it back to True