Help w/ Unit Conversions

thanks for the help! i know the code is in "Module" and "Sheet" mainly because i was using the module on the final sheet and have been storing/logging the changes and updates i make to the code in a folder incase i decide to use the module for something else later. just a personal thing

still haven't been able to put a code together that works around the #N/A value so until then i've had to designate "u" as "1dzn" (1 dozen) for the formula to work. i'd like to avoid this as some of our personnel may get confused, but if this is the only work around for what i'm trying to achive then meh i'm sure i can get my supervisor to allow it.

also, pertaining to what i just mentioned, how would i be able to make it so a msgbox comes up saying "units don't match!" if the value of C3 = #N/A? haven't had luck since the cell contains a formula but this would help if anyone tries to run the macro with non-like units and keeps them out of the vba debug.


thanks again for any help!