View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Mike Fogleman Mike Fogleman is offline
external usenet poster
 
Posts: 1,092
Default selecting cell under a button

You are not giving much detail, but if the button is covering cell A10 then
code
Range("A10"). Select
will select the cell.

Mike F
"Patrick Bateman" wrote in
message ...
is that absolutely not or absolutely? if it i possible, any idea how?


"Mike Fogleman" wrote:

Absolutely. The button is not part of the cell but floating on a layer
above
the cell.

Mike F
"Patrick Bateman" wrote in
message ...
I am running a macro from a button that inserts a new row and copies the
formulas from the row above into it, but when doing this i need to
specify
an
active cell at the point at which the new row is inseted. is it
possible
that
i can insert code that selects the cell the button is on top of?

Thankyou