I have an Excel 2007 spreadsheet which I share with others. We are constantly adding text to it and it is currently up to row 305. When I want to get to the last cell with text in it I press CTRL + END, but it takes me to row 722 every time. I tried deleting rows after row 305 and saving it, but CTRL + END still takes me to row 722. Can I get a macro that will find the last row of text and then go to that row, so I can arrow down and start entering in the next row. I plan to make the macro part of spreadsheet so that anyone who is using the spreadsheet can access the macro. Thanks.