Do the same thing for the PartsLR as you did with the FaultLR
The bit of code you posted will change the formulas to their values with this line
Blank formula results would result in blank cells. The problem is that you determine the last row before you convert the formulas to their values.
I would suggest using a different method for converting the formulas to their values- It will speed up the macro's execution time. Currently you are affecting the entire sheet with the "Cells.Value = Cells.Value" line. Use this instead:
If you've already run the original macro on the sheet without saving and closing the book, my suggestion will be run against the entire sheet since the LastCell is the lower right corner of the spreadsheet due to if being acted upon by the " Cells.Value = Cells.Value"
Bookmarks