SmartView Essbase Submiting data

[Zibi]

Hi,
I am trying to find out a way to submit a data in SmartView (11.1.2.5.810 (Build149)) with VBA. Here is a code i am currently using to test and it works only when the the amounts are static/values but when the amounts are generated by formulas the code does not submit anything. Any ideas?

Sub SubmitData()

Worksheets("Sheet5").Range("Loader").Select
s = HypSubmitSelectedRangeWithoutRefresh(Worksheets("Sheet5"), False, False, False)

End Sub

Thanks
Z