QA Guy,
You need to select all the cells first. And your movement after entry need
to be set to move to the right.
Or, you could use a selection change event, but that is much more
complicated.
HTH,
Bernie
MS Excel MVP
"QAguy" wrote in message
...
I knnow there is a way to "teach" my spreadsheet the range I am entering
data
into. But I don't remember how. The actice cell is supposed to go from
the
last data entry column in the current row, to the first column in the next
row. All I had to do was hit "Enter" and I was ready to enter the next
record. Does anybody remember how?
|