After deleting the columns you must save the workbook to reset the range.

Do not just "clear contents".


Gord Dibben MS Excel MVP


On Mon, 14 Sep 2009 13:00:01 -0700, JFort
wrote:

I'm using Excel 2007 and somehow the worksheet created columns to the right
of my data that affects my horizontal scroll bar. All data is deleted but the
scroll bar won't revert back to the utilized area of the worksheet.