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

To get the activecell row .....

ActiveCell.Row

Also note you can refer to range using

Range(Cells(r1, c1), Cells(r2, c2))

or a single cell as....

Cells(r3, c3) = 1

Where r1 and c1 etc are the row and column numbers. A method that allows you
to loop through using vars to point to the cells-range required

--
Cheers
Nigel



"Daz" wrote in message
ups.com...
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

Nigel wrote:
To get the activecell row .....

ActiveCell.Row

Also note you can refer to range using

Range(Cells(r1, c1), Cells(r2, c2))

or a single cell as....

Cells(r3, c3) = 1

Where r1 and c1 etc are the row and column numbers. A method that allows you
to loop through using vars to point to the cells-range required

--
Cheers
Nigel



"Daz" wrote in message
ups.com...
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

For some reason, my previous reply didnt wrok.

Thats for your assistance - worked a charm.

Darragh

Nigel wrote:
To get the activecell row .....

ActiveCell.Row

Also note you can refer to range using

Range(Cells(r1, c1), Cells(r2, c2))

or a single cell as....

Cells(r3, c3) = 1

Where r1 and c1 etc are the row and column numbers. A method that allows you
to loop through using vars to point to the cells-range required

--
Cheers
Nigel



"Daz" wrote in message
ups.com...
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

For some reason, my previous reply didnt wrok.

Thats for your assistance - worked a charm.

Darragh

Nigel wrote:
To get the activecell row .....

ActiveCell.Row

Also note you can refer to range using

Range(Cells(r1, c1), Cells(r2, c2))

or a single cell as....

Cells(r3, c3) = 1

Where r1 and c1 etc are the row and column numbers. A method that allows you
to loop through using vars to point to the cells-range required

--
Cheers
Nigel



"Daz" wrote in message
ups.com...
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