Hi all.

I'm new to excel VBA programming (I'm an old hand at Access VBA) and
I'm trying to do the following:

1. I have a range of eight cells (E8:N8).
2. When I double click on a cell in that range, it changes its interior
colour, and set the interior colour of every other cell within the
range to 'blank'.

I have this working fine for this individual range. What I have is
multiple ranges - eg.

(E8:N8)
(E9:N9)
(E10:N10)

...and I need to extract the row number of a particular cell when it
double clicked, then using that row value, only 'blank' out the colour
of cells with a range intersecting with that row number. i.e. Click on
cell F10, the all cells in the range E10 to N10 are set to blank, then
F10 is highlighted. So basically, I just need to know how to get the
row value.

I cannot find any examples on the web, and was wondering if anyone
could help out?

Regards
Daz