| 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 |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
BottomRightCell ignores hidden cells
yep tried it - they are not equal
topleft does actually give the ref I was looking for so I'll try that. I can't guess what you are getting at by the "in a cell" comment. The toggle button fully occupies the cell D8, bottom right gives E9 and topleft gives d8 NickHK wrote: 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 |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
BottomRightCell ignores hidden cells
Make the button smaller, so Excel considers completely "in the cell".
But either way, you know it in D8. NickHK wrote in message oups.com... yep tried it - they are not equal topleft does actually give the ref I was looking for so I'll try that. I can't guess what you are getting at by the "in a cell" comment. The toggle button fully occupies the cell D8, bottom right gives E9 and topleft gives d8 NickHK wrote: 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 |
|
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
BottomRightCell ignores hidden cells
I was experimenting with this and I found that for the topleft and
bottomright properties to by the same, the height & width of the button must round [down] to the next snap size for the cell height/width. For example, a row can either be 12 pt or 12.75 pt. The button height must be less than 12.375 for the TL & BR props to be the same. Make any sense? "NickHK" wrote: Make the button smaller, so Excel considers completely "in the cell". But either way, you know it in D8. NickHK wrote in message oups.com... yep tried it - they are not equal topleft does actually give the ref I was looking for so I'll try that. I can't guess what you are getting at by the "in a cell" comment. The toggle button fully occupies the cell D8, bottom right gives E9 and topleft gives d8 NickHK wrote: 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 |
|
#10
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
BottomRightCell ignores hidden cells
Hi
You might also be careful with the Zoom. If a user sets the zoom on the sheet below 100% you might find the topleft value is not D8 anymore! This happened to one of my sheets even though size and rescale was on, and the button dimensions were the height and width of the cell. Excel bug? regards Paul NickHK wrote: Make the button smaller, so Excel considers completely "in the cell". But either way, you know it in D8. NickHK wrote in message oups.com... yep tried it - they are not equal topleft does actually give the ref I was looking for so I'll try that. I can't guess what you are getting at by the "in a cell" comment. The toggle button fully occupies the cell D8, bottom right gives E9 and topleft gives d8 NickHK wrote: 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 |
|
#11
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
BottomRightCell ignores hidden cells
|
|
#13
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
BottomRightCell ignores hidden cells
Yes Bill,
I wrongly assumed topleft was the opposite to bottomright the reason I asked again is based on Paul's comment Bill Pfister wrote: I may be overlooking something, but are you simply looking for the TopLeft cell (property of the button)? " wrote: oh!!! so question still remains. if a toggle button "starts" in a certain cell how can I find the ref of that cell? wrote: Hi You might also be careful with the Zoom. If a user sets the zoom on the sheet below 100% you might find the topleft value is not D8 anymore! This happened to one of my sheets even though size and rescale was on, and the button dimensions were the height and width of the cell. Excel bug? regards Paul NickHK wrote: Make the button smaller, so Excel considers completely "in the cell". But either way, you know it in D8. NickHK wrote in message oups.com... yep tried it - they are not equal topleft does actually give the ref I was looking for so I'll try that. I can't guess what you are getting at by the "in a cell" comment. The toggle button fully occupies the cell D8, bottom right gives E9 and topleft gives d8 NickHK wrote: 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 |
|
#14
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
BottomRightCell ignores hidden cells
Hi
The topleft will do it, but I'd suggest making sure zoom is set to 100% before you do it, that's all. regards Paul wrote: oh!!! so question still remains. if a toggle button "starts" in a certain cell how can I find the ref of that cell? wrote: Hi You might also be careful with the Zoom. If a user sets the zoom on the sheet below 100% you might find the topleft value is not D8 anymore! This happened to one of my sheets even though size and rescale was on, and the button dimensions were the height and width of the cell. Excel bug? regards Paul NickHK wrote: Make the button smaller, so Excel considers completely "in the cell". But either way, you know it in D8. NickHK wrote in message oups.com... yep tried it - they are not equal topleft does actually give the ref I was looking for so I'll try that. I can't guess what you are getting at by the "in a cell" comment. The toggle button fully occupies the cell D8, bottom right gives E9 and topleft gives d8 NickHK wrote: 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 | |||
Linear Mode
