Code highlights additional activecell in addition to what it has to highlight

Originally Posted by LJMetzger

Hi subby,



a. By eliminating 'Select', the other cell was not highlighted.
b. When you had if ... then on the same line, Excel thought the if statement was completed.
It takes a log more space, but I almost always use the following if construction:

If a = b then
  c = d
Endif

Lewis

Just an add on requirement.

I do have to change interior color index of ALL CELLS with a value in it under the r.value cell. I used

Range(r.value, Range("k65536").End(xlUp))

Giving me errors.

Any idea on that ?