Thanks for your answer. I tried it and it solved part of my problem, but I
should probably rephrase my questions b/c I just realized it wasn't very
clear. What I idealy would like is for my cursor or I guess the selection to
automatically move down to the next cell after I've finished typing in one so
that I don't have to hit Enter each time, which adds 600 extra keystrokes to
the other keystrokes I'm already making (I have to do this set 250 times). I
figured that if I could assign a character length to the cells, it would
eliminate the use of the Enter key, but that wasn't the case. I also tried
setting up a macro to no avail.

I basically want to type the numbers 1212122212221221221112 etc, each in its
own cell without hitting enter so the process goes much quicker.

I hope that makes more sense.

Audrey

"VBA Noob" wrote:


Hi,

If you select the cells you want. Then go to data validation. Select
length and change to equal to 1 that will restrict the text length to 1
character.


Next select the 600 cells click into the formula bar just below ariel
and this will allow you to tab throught all the cells

Only other way to avoid pressing enter would be a event macro

VBA Noob


--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=566361