Hello Tim,

Thank you for your reply.
I played around with this a bit myself and ended up taking a different
approach, and it doesn't even require a macro. :)

I have my dimensions in A1, and then I'm extracting the numerical values
into B1, C1 and D1.
=LEFT(A1, SEARCH(" ",A1,1))
=MID(A1,SEARCH("x",A1,1)+1,SEARCH(" x",A1,SEARCH("x
",A1,1)+1)-SEARCH("x",A1,1))
=RIGHT(A1,LEN(A1)-SEARCH("x",A1,SEARCH("x",A1,1)+1))

E1, F1 and G1 then handle the conversions, and H1, I1 and J1 provide me with
the rounded up values.

May not be the most terribly efficient method, but it works.