Hello All,

I am sure this question has been asked many times before and I may just be using the wrong search terms…

I have various workbooks where I have a row at the end with the text END across each column. I use this row as a guide where my formatting and formulas etc. ends (this could equally be the final row where my totals formula is located.). When I am close to this row I insert copies of the rows, to maintain my formulas, totals formulas, formatting, etc.

I know about using .end(xlup) to find the last row, but how can this be run twice ???



For example, the first time it is run in column A it will go up and find the text string END or TOTALS.
How do I get it run again the find the next last blank cell in column A (no formula used in column A).
I would like to be able to click on a button and the last cell in column A above the row with the text or formulas is selected.

Thanking you in advance,
Dave T