Can I know the best and easiest method touse sendkeys
You can use the SendKeys method in your VBA code, to simulate keystrokes that you would manually input in the active window. The SendKeys method has two arguments: SendKeys(Keys, Wait)
The Keys argument is required, and is the key or keys that you want to send to the application, as text.