wie kann ich in der aktiven Zeile die Spalten AU - CF markieren?
Gruß
otto
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Range("AU" & ActiveCell.Row & ":CF" & ActiveCell.Row).Select
End Sub
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim Tr As Long
Tr = Target.Row
Range("AU" & Tr & ":" & "CF" & Tr).Select
End Sub