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.
Bookmarks