View Single Post
  #2   Report Post  
Bernie Deitrick
 
Posts: n/a
Default

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?