Hi, I want to select all of the area on the table attached called data1. All area minus the last column. How do i go about writting a macro like that? A4 to J372 Please advise. Cele