VBA Code for Going Back to Previous Active Cell!

[Rajeshkumar R]

Dear Friends,

Need your support on subjected Query: -

Please refer below code which is working completely fine for me, Except where Red Highlighted!!!

ActiveCell.Row & ActiveCell.Column goes to next Row or next Column based on User Press Tab or Enter Respectively after entry in a current cell!

Requesting you to provide your valuable suggestion, How to Select previous active cell in both the cases, so that it extracts right value from “Data” sheet and paste in “LogDetails” sheet!

Please Login or Register  to view this content.

Thanks & Regards,
Rajeshkumar R

[Norie]

Have you tried using Target instead of ActiveCell?

[nilem]

Hi Rajeshkumar R,

maybe use Target instead of ActiveCell

[Rajeshkumar R]

Dear Norie ,

Thank You So much for your instant Response, Your suggestions met my Requirement!

Regards,
Rajeshkumar R