I just noticed that there are some columns that are "1-3". Your current code turns those numbers into hash tags, ####. 1-3 means numbers 1 thru 3. I need to have those left as they are.
Interesting note: After I run the macro, when I click on the #### column, the Formula url shows the formatting of "1/3/2014" I don't know what's going on.
Open and run the macro (F8) "runing_code_will_change_to_hash-test2.xlsm"
Please see attached file, "problems_with_rows_4-6.xlsm"
|