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.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Roman Numerals Won't Work With Join/Transpose
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.
Upvote
0
