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
|