Hi All (Excel 2007) , Many times I find myself for various reasons selecting cell A1 and highlighting everything on my spread sheet and then pasteing it to another spreadsheet instead of just clicking the slect all tab at the top left of the spreadsheet. Sometimes i filter certain criterias and then specifically select what I filtered. since the area I select changes for every spread sheet I have , what code would I use in a macro to state that I want to specifically highlight and copy from cell A1 to the farthest down and farthest across cell with data and then paste it to a new sheet after the new spreadsheet tab has been clicked?