The code works great! Let me explain the error situation a bit further. There are two types of filters we use, one is a D.E. filter and the other is a sand filter. The D.E. filter area is called out by FT^2 and the sand filter area is called out by SQ. FT.. Usually each job we do only uses one or the other and so if we're using a D.E. filter then the sand filter doesn't show up in our list. When it's not included then I get the error. It converts almost everything within the list but stops about 3/4 of the way through.
I have included a list from one of our jobs on Sheet2 on the attachment so you can run your code on and hopefully you can see what I'm talking about.
Your conversions are definitely one less step. I actually use the same converter your link takes me to, it's the greatest.
|