I have a button on a spreadsheet that inserts a row. simple, trouble is there are other buttons below it. if the 1st one is fired then the next button creates the row in the wrong place cos each button is hardcoded to the row it starts at.

How do I on the button click code detect the row the button sits on? Its as if the button just floats on top of the spreadsheet. I want to assign a button to a cell. Either that or use an image or can u get a cell click event? If so it would solve my problem.

any comments appreciated
j