Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how can you auto return from columns B1 to A2
lets say you r using just 2 columns A and B all i want to do is return to the
start of the next line which would be a2 and so, oh if you highlight both columns it will return to the next line can you do it with out hightlighting. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how can you auto return from columns B1 to A2
If you select all of columns A:B, then use the tab key, does that help?
arran tw wrote: lets say you r using just 2 columns A and B all i want to do is return to the start of the next line which would be a2 and so, oh if you highlight both columns it will return to the next line can you do it with out hightlighting. -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
how can you auto return from columns B1 to A2
Install this Change event sub:
Private Sub Worksheet_Change(ByVal Target As Range) If Target.Column = 2 Then Range("A" & Target.Row + 1).Select End If End Sub It will return to column A in the next line after filling cells in column B. Please post if you need help to install it! Regards, Stefi €žarran tw€ť ezt Ă*rta: lets say you r using just 2 columns A and B all i want to do is return to the start of the next line which would be a2 and so, oh if you highlight both columns it will return to the next line can you do it with out hightlighting. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
how can you auto return from columns B1 to A2
please could you let me know how to install thanks.
"Stefi" wrote: Install this Change event sub: Private Sub Worksheet_Change(ByVal Target As Range) If Target.Column = 2 Then Range("A" & Target.Row + 1).Select End If End Sub It will return to column A in the next line after filling cells in column B. Please post if you need help to install it! Regards, Stefi €žarran tw€ť ezt Ă*rta: lets say you r using just 2 columns A and B all i want to do is return to the start of the next line which would be a2 and so, oh if you highlight both columns it will return to the next line can you do it with out hightlighting. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
how can you auto return from columns B1 to A2
we have been doing it that way but its easy to lose info
"Dave Peterson" wrote: If you select all of columns A:B, then use the tab key, does that help? arran tw wrote: lets say you r using just 2 columns A and B all i want to do is return to the start of the next line which would be a2 and so, oh if you highlight both columns it will return to the next line can you do it with out hightlighting. -- Dave Peterson |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
how can you auto return from columns B1 to A2
Hi Arran,
Press Alt-F11 (launches VB window) Right Click on your worksheet in the Project window Choose View code from the local menu Copy and Paste there the Sub Regards, Stefi €žarran tw€ť ezt Ă*rta: please could you let me know how to install thanks. "Stefi" wrote: Install this Change event sub: Private Sub Worksheet_Change(ByVal Target As Range) If Target.Column = 2 Then Range("A" & Target.Row + 1).Select End If End Sub It will return to column A in the next line after filling cells in column B. Please post if you need help to install it! Regards, Stefi €žarran tw€ť ezt Ă*rta: lets say you r using just 2 columns A and B all i want to do is return to the start of the next line which would be a2 and so, oh if you highlight both columns it will return to the next line can you do it with out hightlighting. |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
how can you auto return from columns B1 to A2
Arran
Another option not involving code. Start in column A, enter data then hit TAB to go to column B. Enter data then hit ENTER key to drop down and back to Column A. On Wed, 12 Jul 2006 00:30:02 -0700, Stefi wrote: Hi Arran, Press Alt-F11 (launches VB window) Right Click on your worksheet in the Project window Choose View code from the local menu Copy and Paste there the Sub Regards, Stefi „arran tw” ezt írta: please could you let me know how to install thanks. "Stefi" wrote: Install this Change event sub: Private Sub Worksheet_Change(ByVal Target As Range) If Target.Column = 2 Then Range("A" & Target.Row + 1).Select End If End Sub It will return to column A in the next line after filling cells in column B. Please post if you need help to install it! Regards, Stefi „arran tw” ezt írta: lets say you r using just 2 columns A and B all i want to do is return to the start of the next line which would be a2 and so, oh if you highlight both columns it will return to the next line can you do it with out hightlighting. Gord Dibben MS Excel MVP |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto return month as text date | Excel Discussion (Misc queries) | |||
Conditional formula - language needed | Excel Worksheet Functions | |||
Columns | Excel Discussion (Misc queries) | |||
How do I convert text to columns when there is a carriage return? | Excel Worksheet Functions | |||
auto filling columns from rows | Excel Discussion (Misc queries) |