Roman Numerals Won't Work With Join/Transpose

[anwaee2]

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 formula combination perfectly. Is there a way around not having to manually type in each Roman numeral number. I have tried both worksheet formulas and VBA code to no avail. Has anyone else ran up against this and if so is there a fix for this. Thanks again to all the help I have received in the past.

 

[mole999]

can you post something from htmlmaker or similar so we can see what you have and the code supporting

 

[anwaee2]

Sorry for not getting back sooner. Gone for the holidays. Thanks for getting back. Join/transpose doesn't seem to work with formulas or maybe the formatting of Roman Numerals. I ended up using a helper column with the formula "=Roman(**) and then I did a copy/paste special using xlPasteValues and now it works fine. Thanks again for getting back and for all the other help I have received in the past.