Is there a dependable way to cause Excel to set the used range (i.e., last row, last column) of a worksheet other than saving the workbook? I have an application where I filter a sheet and then delete all visible rows. When I copy that sheet to another sheet, the used ranges of each sheet do not agree. By accident, if I msgbox the function xllastrow of each sheet, then they agree. But I don't want to msgbox and I don't want to save teh workbook. Thanks.