| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Offset every 27th row in a column that is 2 cells wide (merged cel | Excel Worksheet Functions | |||
| Offset and Merged cells | Excel Programming | |||
| Navigating with keyboard after using offset on merged cells | Excel Programming | |||
| Offset function with merged cells | Excel Programming | |||
| how to offset when it is a merged cell. | Excel Programming | |||
Linear Mode
