Suppressing Oracle Error Message in VBA

[mdluiz16]

Hi All,

I have a macro that refreshes a ton of sheets with Essbase, and for each sheet that I refresh I run into an error saying "Oracle Smart View for Office: Cannot change part of a merged cell." Is there any way I can suppress this error message from popping up? Disabling display alerts does not solve my issue because this is an add-in application. Is there code I could modify in the SmartViewVBA module in order to suppress ONLY this error message?

Thanks

 

[JackDanIce]

Unmerge the cells or in code use On Error Resume Next before the line that causes that error. I'd advise to never use merged cells though, disabling errors means later errors may not be picked up.