Merged cells .Offset(row,Col) inconsistancies
 

I created a worksheet that has several merged cells (3*3) rimmed on two edges
by seven(7) protected cells. There are 7 buttons, each of which will change
the color of one and only one of the protected cells rimming the current cell.

Problem: If the current cell is in row 2 or column B the range statement
takes me to the wrong cell.

Will e-mail test worksheet
--
roypeck

Merged cells .Offset(row,Col) inconsistancies
 

What's the range statement which doesn't work? Where are the protected and
merged cells?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Roy Peck" wrote in message
...
I created a worksheet that has several merged cells (3*3) rimmed on two
edges
by seven(7) protected cells. There are 7 buttons, each of which will
change
the color of one and only one of the protected cells rimming the current
cell.

Problem: If the current cell is in row 2 or column B the range statement
takes me to the wrong cell.

Will e-mail test worksheet
--
roypeck