Insert row macro at the end of a changing data set

Hello guys,

I currently have data inputted into a cell range from B7:I48 and I have a macro that when selected or executed will make a new row on line 49. If this button is selected again, it will add a row on 49 instead of at the end of the new dataset line 50. As the dataset expands down, I would like the macro to insert a row on the line right after the data set. My current code is as follows below. Please advise on how this code should be adjusted. Thank you very much.

Please Login or Register  to view this content.

Will it always start at row 49?

Do you have a sample that you can upload showing your data is structured? You can put dummy data as long as the format remains the same as your original.

To Attach a File:

1. Click on Go Advanced
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.

So, you will have data uptil row 48, so the macro has to add a row at 49. Then at the end of the next dataset. How will the macro know where the next row should be inserted? Is there already a blank row there and you need another blank row to be added? Your sample shows only one dataset so its tough to make out.

Or will there be some text in a particular cell? So if the macro finds that text, a row needs to be inserted?