Visit http://www.TeachMsOffice.com for more, including Excel Consulting, Macros, and Tutorials.

Learn how to write a Macro in Excel to find the very last row and the very last column in a spreadsheet. This tutorial shows you how to select and return the cell position for the last cell with data in a row and column. You will learn how to change this macro to find the end of data for your workbooks and spreadsheets and how to select these cells using this Excel Macro. This is a great tutorial for when you need to find then end of ranges in Excel Worksheets.

For Excel consulting or to get the spreadsheet or macro used here visit the website http://www.TeachExcel.com There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel.

Have a great day!