#1
|
|||
|
|||
Macro doesn't work
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 |
#2
|
|||
|
|||
Call SaveSetting("Benzinstatistik", "Verbrauch", "Euro100km", [AVGVerbrauch])
Currently you are referring to variable AVGVerbrauch, which probably isn't even defined! |
#3
|
|||
|
|||
Thank you very much!!! It works!
Regards - Dietrich |
Tags |
macro named cell value |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Spell check macro within macro button field doesn't work in one document | samuelle | Word VBA | 0 | 07-20-2016 02:27 AM |
SaveAs Doesn't work | royersebastien | Word VBA | 0 | 03-23-2016 01:29 AM |
SHIFT+END doesn't work | derohanes | Excel | 2 | 09-28-2015 09:31 AM |
HelpViewer doesn't work | dherr | Office | 1 | 03-27-2015 07:44 AM |
CNTL+X doesn't work | ACA | Office | 3 | 09-19-2011 10:42 AM |