R
Rentapen
I have a nice little sheet background 2 except;
my header is gray (3 rows 1,2,3) and 2 columns (gray, I and M i think) which
shows results.
I need to modify this dity so if i click a upper 3 rows or on one of my 2
columns it doesn't stay #2
(my lower oldrange).
(it returns after column 11).
any Ideals?
regards.
just wandering
rentapen
***
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
With ActiveWindow
If Target.Column > 11 Then
ActiveCell.Offset(1, 1 - Target.Column).Select
End If
End With
Static OldRange As Range
On Error Resume Next
Target.Interior.ColorIndex = 6
OldRange.Interior.ColorIndex = 2
Set OldRange = Target
End Sub
***
my header is gray (3 rows 1,2,3) and 2 columns (gray, I and M i think) which
shows results.
I need to modify this dity so if i click a upper 3 rows or on one of my 2
columns it doesn't stay #2
(my lower oldrange).
(it returns after column 11).
any Ideals?
regards.
just wandering
rentapen
***
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
With ActiveWindow
If Target.Column > 11 Then
ActiveCell.Offset(1, 1 - Target.Column).Select
End If
End With
Static OldRange As Range
On Error Resume Next
Target.Interior.ColorIndex = 6
OldRange.Interior.ColorIndex = 2
Set OldRange = Target
End Sub
***