I went into the file again yesterday and tried something I thought I had before- clearing the formatting on every line without data on all 6 tabs of the worksheet. I believe that may have done the trick so we can put this in the "solved" bucket. I will look at the re-direct for possible future reference- thanks!