Macro to delete set of cells but return to original cell

[hani9041]

Hi Guys,

I'm looking to build a macro that after a certain action a set of cells are deleted but I don't want it to disrupt the user's work flow. Currently I have the following code (below) but after it deletes the specified cells it remains highlighting the cells. Do for example user 1 is makes a change in cell A1 and the code is invoked, I'd like the macro to select the the following cell in this case A2. Thought on how I can achieve this.

Please Login or Register  to view this content.

Thanks,
+HZ

[Kelshaer]

you dont have to select.
Use this

Please Login or Register  to view this content.

[Mordred]

You should be able to simply use

Please Login or Register  to view this content.

[hani9041]

Thank you Khaled and Mordred, works like a charm.
+HZ