|
|
#1
05-16-2023, 12:59 AM
|
|||
|
|||
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
05-16-2023, 01:19 AM
|
|||
|
|||
|
Call SaveSetting("Benzinstatistik", "Verbrauch", "Euro100km", [AVGVerbrauch])
Currently you are referring to variable AVGVerbrauch, which probably isn't even defined!
|
|
| 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 |
Windows 11 
Office 2007
Linear Mode
