Format a range of cells to numerical values.

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.

Please Login or Register  to view this content.

Please read the VBEditor's help item With... End With
Every property of an object has to be preceded by a dot.

Please Login or Register  to view this content.

Try putting a period in front of the word Range (.Range).

This will tell the macro that the Range to format is on the With ... (workbook??)

On a second look...

I think you need to specify what worksheet the range is pointing.

How about putting

Please Login or Register  to view this content.

I just recorded a macro to do the above and it looks like:

Please Login or Register  to view this content.

Maybe you should be uisng Columns instead of Range?

I agree but using Columns instead of Range may solve the problem.

I don't think so.
Range isn't a property of a workbook but of a worksheet
one line suffices:

Please Login or Register  to view this content.