When the cursor is going into a cell (when hitting the enter key), nee
the cell to contain a default value of the cell above it. Kinda lik
control + ' , except not be in the edit cell mode.

Any ideas?

mikebur

--
mikebur
-----------------------------------------------------------------------
mikeburg's Profile: http://www.excelforum.com/member.php...fo&userid=2458
View this thread: http://www.excelforum.com/showthread.php?threadid=38245