Hi Howard,

Am Sun, 28 Feb 2016 02:08:48 -0800 (PST) schrieb L. Howard:

A bit tricky, I can see for sure I would never got it correct.

it is easy:

1. The highlighted column depends on the selected row number
2. So you want to highlight every second column you have to multiply the
row number by 2
3. You start selection in row 2 and need column 3. So you have to
substract 1
column number = target.row *2 - 1

Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional