Tag Archives: Excel VBA

From a little less than a year, I had plans to learn VBA basics for Excel. As an SAP BPC Consultant I am not expected to be a master of it, but there is no doubt it is a useful programming language in a variety of cases. As a rule of a thumb, SAP BPC Consultants should avoid extensive usage of VBA, especially for sophisticated calculations. However there are circumstances where you will need to automate tasks such as changing chart source data, chart title, copying excel formulas to dynamic input forms, etc. Initially, I was …