Thread: Column stop
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
NickHK[_3_] NickHK[_3_] is offline
external usenet poster
 
Posts: 415
Default 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