Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
insert row above button (retrieve position of button)
Hi,
I want to create a simple macro that inserts a row above the button one clicks. Since the position of this button will change when adding/removing rows, I can not give a reference where to insert the row, therefore I want it to be inserted relative to the position of the commandbutton. Can I get a reference (rownumber) from such a button, such that I can base the insertionpoint on this info? Thanks a lot! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Command Button Position | Excel Discussion (Misc queries) | |||
change position of filter button | Excel Worksheet Functions | |||
Insert Subtotal button | Excel Worksheet Functions | |||
INSERT NEW ROW MACRO BUTTON | Excel Discussion (Misc queries) | |||
Insert Row before Macro Button | Excel Discussion (Misc queries) |