Skip to Content

EPM Formatting Through VBA Code (Macros) - SAP BPC 10.0

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

macro-1.jpg (20.3 kB)
macro-2.jpg (22.8 kB)
macro-3.jpg (8.5 kB)
macro-4.jpg (23.1 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    May 11 at 06:01 AM

    Sorry, but Columns return range object having property:

    NumberFormat

    Not

    number_format

    Add comment
    10|10000 characters needed characters exceeded

  • May 11 at 06:05 AM

    P.S. Please accept answer on your previous question!

    Add comment
    10|10000 characters needed characters exceeded