I am recording a macro which will update formulas in a worksheet based on a new table which is pasted into a different worksheet monthly. I am trying to reference the last cell containing text in a column. I have tried using Ctrl downarrow while recording the macro, but when I look at the code, a cell reference is used. To test out the macro I inserted more rows in the main sheet and it is not referencing the last cell, regardless of how many rows there are. How can I get excel to "go to the last entry in this column" and use that cell as a reference on another sheet. Each month I want to run the macro so it will automatically use values from the last row, whatever the row number.