Use

Sendkeys {ENTER}
or
Sendkeys ~

See vb help using keyword sendkeys

Cheers

Joe


"JMay" wrote in message
news:USHgb.45210$AH4.15989@lakeread06...
I've got code that is working up to a point **and stops** -- the screen
(bottom left shows I'm in Edit Mode) - and the cursor is "inside" a
cell --
all that I have to do is manually press enter and it completes. soooooo
obviously I'd like to incorporate this "last-step" in the code. Can
someone
tell me what I should add to the code to have it complete the update.
TIA,