| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how do I select cells in column A thru F in the active row?
What I'm tring to do is select cells in column A thru F in whatever row is
active no matter what cell in what column is active. I know it's simple but I forgot how to do it. Thanks Jon |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how do I select cells in column A thru F in the active row?
One way:
Range(Cells(ActiveCell.Row, 1), Cells(ActiveCell.Row, 6)).Select Regards Rowan "jonco" wrote: What I'm tring to do is select cells in column A thru F in whatever row is active no matter what cell in what column is active. I know it's simple but I forgot how to do it. Thanks Jon |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how do I select cells in column A thru F in the active row?
Place this code into the worksheet (Right Click the tab and select View Code)
Private Sub Worksheet_SelectionChange(ByVal Target As Range) On Error GoTo ErrorHandler Application.EnableEvents = False Range(Cells(Target.Row, "A"), Cells(Target.Row, "F")).Select ErrorHandler: Application.EnableEvents = True End Sub -- HTH... Jim Thomlinson "jonco" wrote: What I'm tring to do is select cells in column A thru F in whatever row is active no matter what cell in what column is active. I know it's simple but I forgot how to do it. Thanks Jon |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how do I select cells in column A thru F in the active row?
Thanks guys. Perfect.
|
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how do I select cells in column A thru F in the active row?
A bit easier/shorter:
Cells(ActiveCell.Row,1).Resize(1,6).Select Bob Umlas Excel MVP "Rowan" wrote in message ... One way: Range(Cells(ActiveCell.Row, 1), Cells(ActiveCell.Row, 6)).Select Regards Rowan "jonco" wrote: What I'm tring to do is select cells in column A thru F in whatever row is active no matter what cell in what column is active. I know it's simple but I forgot how to do it. Thanks Jon |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Row select mode to highlight active row of active cell | Excel Discussion (Misc queries) | |||
| Selecting all the active cells in a named column. | Excel Worksheet Functions | |||
| Select Active Cells | Excel Worksheet Functions | |||
| Tools/Options/Charts-Active cells is dimmed. Want to select leave | Charts and Charting in Excel | |||
| Select column cells to the left/right of active selection - an example | Excel Programming | |||
Linear Mode
