I am trying to create a macro that inserts a few rows after the last full cell. These rows will be copied from another part of the worksheet and contain formulas.
I found a post that shows how to find the last full cell, but I can't incorporate this into a macro that inserts lines there. Any help is appreciated.
I was hoping not to get too verbose, but here it goes.
We have a spreadsheet that right now has a couple of hundred lines. In these rows, some of the cells are blank and some have quite lengthy formulas in them waiting to calculate for when we enter stuff into the blank cells(we use this as part of our estimating process).
The problem is that we don't always use all of the rows so there are a lot of unnessecary blank rows with formulas in them and the file sizes are getting pretty big. What I want to do is to be able to add lines (10 at a time) to the bottom of my spreadsheet. These lines won't be blank because they will have my formulas in them. That way, I will only have the amount of lines I need.
I cleared out a lot of stuff on the file, but the general idea should be illustrated. Look at the "test" sheet. Let me know if I am unclear.