Hello (I'm German),




I have a Workbook with a Sheet named Daten. On this Sheet I have a Cell named AVGVerbrauch.

And this is my Macro in the Sheet Calculate:


Private Sub Worksheet_Calculate()
Call SaveSetting("Benzinstatistik", "Verbrauch", "Euro100km", AVGVerbrauch)
End Sub


The AVGVerbrauch is the cell Daten!$F$75 on Sheet Daten.


The problem is, when I use this function call the AVGVerbrauch shows always NULL and not the real value of 7,22 of the Cell.


What is wrong?


Regards - Dietrich