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