on 05-11-2018 6:50 AM
Hello Experts,
In one of our BPC template, number formatting for figures have been done through VBA code (Refresh Macro) as mentioned below which applies to full sheet.
and works proper:
But there is an additional requirement with respect to some of the columns where formatting is different (color changes) for that we have added the below code:
Post refreshing the template it is giving below error with same additional line item:
Any suggestions for code syntax.
Thanks,
Karan
Sorry, but Columns return range object having property:
NumberFormat
Not
number_format
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
The code:
Range("CQ:DG").NumberFormat = "[Red]#,##0.00;-#,##0.00;- ;"
is absolutely correct and is working in my test macro. It will make positive numbers red (strange idea by the way).
Why it's not working in your code? May be ElseIf is not true...
And have to repeat - it's a bad idea to ask new question without reaction on previous one!
P.S. Please accept answer on your previous question!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
6 | |
5 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.