How does one refresh the UsedRange object? For instance, I type a value in the cell A1 and then type another value in the cell G55. The Used Range then becomes A1:G55. If I now erase the contents of the cell G55 and type some content in the cell D12. Although the area being used by the spreadsheet now is only A112, the UsedRange object still contains the area A1:G55. How do I flush the contents of the UsedRange object to reflect its new range?