Minor modification to existing macro (insert data without clearing contents of rows above)

Hi all!

I am on the final stretch of my project, and thought I had a better handle on creating macros, but I am having a tough time figuring this out. Here is the issue I am having. Please help!!

I have two macros in this spreadsheet: (I have command buttons in the ribbon -- "Pre-Payment Macros")
1. Insert Pre-Payment Tab
2. Insert Data

When I run the Insert Pre-Payment Tab macro, it works great. But, when I run the Insert Data macro afterward, it deletes the second line of my table (it deletes the contents of row 2).

So, there is something in the second macro that needs to be edited.

When the first macro is run, the cursor is in cell A3, which is great. I need the second macro to place the data into cell A3 (without clearing the contents of row 2).

Any help is greatly appreciated! I am attaching the spreadsheet, along with the code for the second macro below.

Please Login or Register  to view this content.

Okay, thanks a bunch. I will try that now.

You rock!! It works, thanks a bunch!