Macros and cell selection

I record a lot of macros and can go into VB to manipulate them, but a programer I am not. I could really use some programming help right now.

I'm recording a macro to insert rows into a spreadsheet that is divided into sections. Section 1 runs from (A40:T52) with cell N53 being named SubA (it totals N40:N52). If I insert a row, SubA becomes cell N54 and inserting 2 rows would make it N55. I would like to insert individual rows as needed in the row above SubA (as well as SubB, SubC, SubD, and SubE). I can select SubA and I know the code to insert a row, but I can't figure out how to move up 1 cell without it referencing a specific cell (N52). That works for the first row I insert, but when I insert a second row, it will insert a blank row between data. I'm working on making this as user friendly as possible because the users won't be excel savy. Could anyone help me figure out what goes where the 3 ?'s are below in the lines of code? I would really appreciate the help.

Please Login or Register  to view this content.

Thank you,

Roy

Hello royhobbs19,

Welcome to the Forum!

Perhaps this will help . This macro is a User Defined Function. It works like a worksheet formula and entered the same way in the cell with an equal "=" sign before it. You only need to include the starting cell. The macro will start summing from that cell to the cell above the macro and display the resulting sum in the cell with contains the macro.

Please Login or Register  to view this content.

Adding the Macro
1. Copy the macro above pressing the keys CTRL+C
2. Open your workbook
3. Press the keys ALT+F11 to open the Visual Basic Editor
4. Press the keys ALT+I to activate the Insert menu
5. Press M to insert a Standard Module
6. Paste the code by pressing the keys CTRL+V
7. Make any custom changes to the macro if needed at this time.
8. Save the Macro by pressing the keys CTRL+S
9. Press the keys ALT+Q to exit the Editor, and return to Excel.
Example

Please Login or Register  to view this content.