Format cells programmatically
Posted on 2014-02-04
I have a range of cells in an Excel worksheet, columns B through Z and rows 2 through 100. I need to set the format of each cell in that range to numeric, no decimals and negative numbers represented by parenthesis instead of a minus sign. How do I do it programmatically? I already have a macro that does some other stuff. I just need to add a routine to it to accomplish what I just described. Thank you.