Column stop
 

I am looking for a way that when I hit enter it goes to the next cell but
stops at Column C. I found a way to make the direction go right but need it
to stop at that column and return to the row below.

Thanks,
Aaron

Column stop
 

Aaron,
Set the .ScrollArea of the Worksheet to the range.address you wish to allow.
Note this setting is not saved with the workbook, so you have to set it each
time the WB is opened.

NickHK

"Aaron" ...
I am looking for a way that when I hit enter it goes to the next cell but
stops at Column C. I found a way to make the direction go right but need
it
to stop at that column and return to the row below.

Thanks,
Aaron

Column stop
 

Select the range of cells you want to use and then only use enter or tab, not
the arrow keys.

--
Regards,
Tom Ogilvy


"Aaron" wrote:

I am looking for a way that when I hit enter it goes to the next cell but
stops at Column C. I found a way to make the direction go right but need it
to stop at that column and return to the row below.

Thanks,
Aaron