I am integrating the code into our spreadsheet which for some reason gives me errors (discussed in post #20). I can create a new sheet within the spreadsheet and have the program run there without any error, however it would be nice use it on a current tab and have the code work. I would like to try one last thing before resulting to creating a new sheet.



As per your quote in post #23Because all dimension are given in inches (besides the pump feet which is already converted) there is no need for the "*12+0" code. So maybe if I alter the line of code to only handle the inches (IN and ") then maybe that will clear the error.

I have tried to alter the line of code but I'm wasn't fully confident in what I was doing with that line, plus what I was doing wasn't working.

I realize you don't get the error as we have discussed earlier but just maybe if we eliminate any code that pertains to a feet and inch dimension (ex. 2'-4" or 1'3") which doesn't exist in the list then maybe the error will go away. It is my last effort and then I will accept that I need to add it to a new sheet. Thanks for hanging in there with me and for all your help Paul.