Through a Macro in Excel 2003, I was able to select an entire worksheet (all of the cells)and delete all of the data in the worksheet.
When I converted it to Excel 2007, I am no longer able to select the entire worksheet and delete all of the data - I get an error that makes Excel "not responsive". Apparently selecting all of the cells is too much -
Is there a way to select a range starting with A1 and ending with the lowest & furthest right data? The amount of data in the sheet varies widely with selected dates (and no - the furthest right column might not have the largest row number)
Thanks -
When I converted it to Excel 2007, I am no longer able to select the entire worksheet and delete all of the data - I get an error that makes Excel "not responsive". Apparently selecting all of the cells is too much -
Is there a way to select a range starting with A1 and ending with the lowest & furthest right data? The amount of data in the sheet varies widely with selected dates (and no - the furthest right column might not have the largest row number)
Thanks -