Pick cell yellow where I want

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

***
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top