Again I have to rely on this forum for I am stumped. I have a column with Roman numerals created with the "Roman" worksheet formula. When I run my macro, it works but all the numbers come up as zeros. If I type the Roman numeral in the cells manually, it will work with the join/transpose...