Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I stop scrolling from column to column ? | Excel Worksheet Functions | |||
Stop Dublication in the same column | Excel Programming | |||
how do I set my tab to stop at column N and rtn to A | Excel Discussion (Misc queries) | |||
How can i stop same data being repeated in a column | Excel Discussion (Misc queries) | |||
stop the column widths from changing | Excel Programming |