Sub dwight()
Application.SendKeys "{ENTER}"
DoEvents
Application.SendKeys "{F2}"
Application.SendKeys "{ENTER}"
DoEvents
Application.SendKeys "{HOME}"
End Sub

You may need to back up a row.
--
Gary''s Student - gsnu200715


"Dwight" wrote:

I want to create a macro that will start in the current cell, give a carriage
return to go to the cell below, give a F2 keystroke, then a Home keystroke
and end.

I know this is very basic, but I can't seem to get it to work.

Any assistance will be greatly appreciated.