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

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

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

how do I select cells in column A thru F in the active row?
 

Thanks guys. Perfect.

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