| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
BottomRightCell ignores hidden cells
The BottomRightCell property of a button returns the position of the
closest bottom right "visible" cell I need the position of the toggle button (which only occupies one cell) Any ideas how please |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
BottomRightCell ignores hidden cells
Which "position" do you need and for what purpose? The Shape properties of
the toggle button (top, left, height, weight) can give you the position regardless of the TopLeft or BottomRight cells. Regards, Bill " wrote: The BottomRightCell property of a button returns the position of the closest bottom right "visible" cell I need the position of the toggle button (which only occupies one cell) Any ideas how please |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
BottomRightCell ignores hidden cells
Bill,
The toggle button exists and is the size of of one cell only. I need the posiiton (row/column) of that cell. The reason is that I need to hide and unhide columns to its right. Thanks Bill Pfister wrote: Which "position" do you need and for what purpose? The Shape properties of the toggle button (top, left, height, weight) can give you the position regardless of the TopLeft or BottomRight cells. Regards, Bill " wrote: The BottomRightCell property of a button returns the position of the closest bottom right "visible" cell I need the position of the toggle button (which only occupies one cell) Any ideas how please |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
BottomRightCell ignores hidden cells
If the button is wholly within the cell,
..TopLeftCell.Address=.BottomRightCell.Address . NickHK wrote in message oups.com... Bill, The toggle button exists and is the size of of one cell only. I need the posiiton (row/column) of that cell. The reason is that I need to hide and unhide columns to its right. Thanks Bill Pfister wrote: Which "position" do you need and for what purpose? The Shape properties of the toggle button (top, left, height, weight) can give you the position regardless of the TopLeft or BottomRight cells. Regards, Bill " wrote: The BottomRightCell property of a button returns the position of the closest bottom right "visible" cell I need the position of the toggle button (which only occupies one cell) Any ideas how please |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
BottomRightCell ignores hidden cells
are you sure about that?
"displays the address of the cell beneath the lower-right corner " is the functionality of bottom right. I suggest that the the statement below can never be true??? NickHK wrote: If the button is wholly within the cell, .TopLeftCell.Address=.BottomRightCell.Address . NickHK wrote in message oups.com... Bill, The toggle button exists and is the size of of one cell only. I need the posiiton (row/column) of that cell. The reason is that I need to hide and unhide columns to its right. Thanks Bill Pfister wrote: Which "position" do you need and for what purpose? The Shape properties of the toggle button (top, left, height, weight) can give you the position regardless of the TopLeft or BottomRight cells. Regards, Bill " wrote: The BottomRightCell property of a button returns the position of the closest bottom right "visible" cell I need the position of the toggle button (which only occupies one cell) Any ideas how please |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
BottomRightCell ignores hidden cells
Did you try it ?
Depends if what you mean "in a cell" is the same as Excel. NickHK wrote in message ups.com... are you sure about that? "displays the address of the cell beneath the lower-right corner " is the functionality of bottom right. I suggest that the the statement below can never be true??? NickHK wrote: If the button is wholly within the cell, .TopLeftCell.Address=.BottomRightCell.Address . NickHK wrote in message oups.com... Bill, The toggle button exists and is the size of of one cell only. I need the posiiton (row/column) of that cell. The reason is that I need to hide and unhide columns to its right. Thanks Bill Pfister wrote: Which "position" do you need and for what purpose? The Shape properties of the toggle button (top, left, height, weight) can give you the position regardless of the TopLeft or BottomRight cells. Regards, Bill " wrote: The BottomRightCell property of a button returns the position of the closest bottom right "visible" cell I need the position of the toggle button (which only occupies one cell) Any ideas how please |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is there a way to write an equation that ignores cells that have . | Excel Worksheet Functions | |||
| Sum function which ignores hidden rows | Excel Worksheet Functions | |||
| Did I stump everyone? Counter that ignores hidden rows | Excel Discussion (Misc queries) | |||
| How do i get an average that ignores blanks in the range of cells. | Excel Worksheet Functions | |||
| ignores hidden columns? | Excel Programming | |||
Hybrid Mode
