Skip to Content
0
May 11, 2018 at 05:50 AM

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

276 Views

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

Attachments

macro-1.jpg (20.3 kB)
macro-2.jpg (22.8 kB)
macro-3.jpg (8.5 kB)
macro-4.jpg (23.1 kB)