Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help please on a simple macro to insert rows
Hi there
I am not an advanced user of excel and want to create a macro which will insert a row in a spreadsheet but will also insert a formula into a cell. I would like the user to be able to click on a button which will say insert row. Any help would be much appreciated. I cannot use visual basic so have tried it out already just by using the wizard to record the macro, I half suceeded and have been able to insert the row but not a formula and have no idea how to create the box to be clicked on to run the macro. Cheers |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help please on a simple macro to insert rows
take a look at David McRitchie's INSRTROW() macro:
http://www.mvps.org/dmcritchie/excel/insrtrow.htm and his excellent Getting Started with Macros page: http://www.mvps.org/dmcritchie/excel/getstarted.htm In article , (Michelle Curtin) wrote: Hi there I am not an advanced user of excel and want to create a macro which will insert a row in a spreadsheet but will also insert a formula into a cell. I would like the user to be able to click on a button which will say insert row. Any help would be much appreciated. I cannot use visual basic so have tried it out already just by using the wizard to record the macro, I half suceeded and have been able to insert the row but not a formula and have no idea how to create the box to be clicked on to run the macro. Cheers |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
macro to insert rows | Excel Discussion (Misc queries) | |||
A Macro to Insert Rows | Excel Discussion (Misc queries) | |||
Insert Rows Macro | Excel Discussion (Misc queries) | |||
asking again, macro to insert rows | Excel Worksheet Functions | |||
macro to insert rows. | Excel Programming |