Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Looks like I solved the Question myself.
Usefull if you enter the same number twice on the same row. It's esay to do Sub LookDoubleAgain() For Each c In Range("C2:V2201") If c.Value = Cells(c.Row, c.Column + 1).Value Then Range(c, c.Offset(0, 1)).Select With Selection.Interior .ColorIndex = 15 .Pattern = xlSolid End With End If Next Range("A1").Select End Sub Hopes this helps someone! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
sustain numbers with double quotes | Excel Discussion (Misc queries) | |||
How does one double sequential numbers in rows? | Excel Discussion (Misc queries) | |||
recognizing double digit numbers in code | Excel Discussion (Misc queries) | |||
double axis, double problem (i hope only to me) | Charts and Charting in Excel | |||
Macro to mark double numbers in another colour. | Excel Programming |