Helo everyone. I have a small scipt of code (courtesy of some developers from this forum) that I have used to automate a task. I have further updated that code to perform additional requirements. However one requirment I need I have not been able to figure.
As you can tell from the code below the variable constCPSelection is valued as a string and that is fine. However I need the ranges "K:K", "L:L", and "M:M" to be formated as numerical values. I added some code at the end (please see comment), and clearly it does not work. Any suggestions?
Better put in the worksheet constFileNameMTMReport
that is created - I need columns K, L and M to be formatted with a comma and two decimal points.
Bookmarks