Hi, I have a macro that rotates custom number formats in selected area:
Everything works fine except from the last format used. Instead of yyy/mm the result is like yyy.mm. The slash is somehow not recognized. Does anybody have an idea for a workaround?
I think it's worth mentioning, that using standard Format cells dialog, it works like a charm. With the difference that regional (Czech) verison of format is required here ("rrr/mm" -> 2014/06). When using macro, on the contrary, only english formats work, as you can see in the format before last in my code.
Thanks.
Bookmarks