http://vba-wiki.net/index.php?action=history&feed=atom&title=Variant Variant - Versionsgeschichte 2026-04-29T07:14:12Z Versionsgeschichte dieser Seite in VBA-wiki MediaWiki 1.39.1 http://vba-wiki.net/index.php?title=Variant&diff=766&oldid=prev Pwania am 28. Januar 2023 um 00:40 Uhr 2023-01-28T00:40:15Z <p></p> <table style="background-color: #fff; color: #202122;" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="de"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Nächstältere Version</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Version vom 28. Januar 2023, 00:40 Uhr</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l1">Zeile 1:</td> <td colspan="2" class="diff-lineno">Zeile 1:</td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">[[Category:vba-wiki]]</ins></div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>Eine als Variant deklarierte Variable kann einen beliebigen Wert entgegennehmen, inklusive einer Objektreferenz.  </div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>Eine als Variant deklarierte Variable kann einen beliebigen Wert entgegennehmen, inklusive einer Objektreferenz.  </div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td></tr> </table> Pwania http://vba-wiki.net/index.php?title=Variant&diff=579&oldid=prev Pwania: /* Nachteile des Variant */ 2019-06-21T17:36:29Z <p><span dir="auto"><span class="autocomment">Nachteile des Variant</span></span></p> <table style="background-color: #fff; color: #202122;" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="de"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Nächstältere Version</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Version vom 21. Juni 2019, 17:36 Uhr</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l53">Zeile 53:</td> <td colspan="2" class="diff-lineno">Zeile 53:</td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>  Debug&lt;span style=&quot;Color:gray&quot;&gt;.&lt;/span&gt;Print lngTest &lt;span style=&quot;Color:gray&quot;&gt;/&lt;/span&gt; &lt;span style=&quot;Color:gray&quot;&gt;4&lt;/span&gt; &lt;span style=&quot;Color:green&quot;&gt;&#039; 3&lt;/span&gt;</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>  Debug&lt;span style=&quot;Color:gray&quot;&gt;.&lt;/span&gt;Print lngTest &lt;span style=&quot;Color:gray&quot;&gt;/&lt;/span&gt; &lt;span style=&quot;Color:gray&quot;&gt;4&lt;/span&gt; &lt;span style=&quot;Color:green&quot;&gt;&#039; 3&lt;/span&gt;</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>  lngTest &lt;span style=&quot;Color:gray&quot;&gt;=&lt;/span&gt; &lt;span style=&quot;Color:gray&quot;&gt;&quot;Max&quot;&lt;/span&gt;                &lt;span style=&quot;Color:green&quot;&gt;&#039; Fehler schon bei der Zuweisung: Max ist keine Zahl!&lt;/span&gt;</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>  lngTest &lt;span style=&quot;Color:gray&quot;&gt;=&lt;/span&gt; &lt;span style=&quot;Color:gray&quot;&gt;&quot;Max&quot;&lt;/span&gt;                &lt;span style=&quot;Color:green&quot;&gt;&#039; Fehler schon bei der Zuweisung: Max ist keine Zahl!&lt;/span&gt;</div></td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div> </div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"> </ins></div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>  &lt;span style=&quot;Color:green&quot;&gt;&#039; Diese Zeile würde selbstverständlich auch einen Fehler erzeugen, aber er ist schon bei der Zuweisung aufgefallen:&lt;/span&gt;</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>  &lt;span style=&quot;Color:green&quot;&gt;&#039; Diese Zeile würde selbstverständlich auch einen Fehler erzeugen, aber er ist schon bei der Zuweisung aufgefallen:&lt;/span&gt;</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>  Debug&lt;span style=&quot;Color:gray&quot;&gt;.&lt;/span&gt;Print varTest &lt;span style=&quot;Color:gray&quot;&gt;/&lt;/span&gt; &lt;span style=&quot;Color:gray&quot;&gt;4&lt;/span&gt;</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>  Debug&lt;span style=&quot;Color:gray&quot;&gt;.&lt;/span&gt;Print varTest &lt;span style=&quot;Color:gray&quot;&gt;/&lt;/span&gt; &lt;span style=&quot;Color:gray&quot;&gt;4&lt;/span&gt;</div></td></tr> </table> Pwania http://vba-wiki.net/index.php?title=Variant&diff=578&oldid=prev Pwania: /* Nachteile des Variant */ 2019-06-21T17:36:08Z <p><span dir="auto"><span class="autocomment">Nachteile des Variant</span></span></p> <table style="background-color: #fff; color: #202122;" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="de"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Nächstältere Version</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Version vom 21. Juni 2019, 17:36 Uhr</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l52">Zeile 52:</td> <td colspan="2" class="diff-lineno">Zeile 52:</td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>  lngTest &lt;span style=&quot;Color:gray&quot;&gt;=&lt;/span&gt; &lt;span style=&quot;Color:gray&quot;&gt;12&lt;/span&gt;</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>  lngTest &lt;span style=&quot;Color:gray&quot;&gt;=&lt;/span&gt; &lt;span style=&quot;Color:gray&quot;&gt;12&lt;/span&gt;</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>  Debug&lt;span style=&quot;Color:gray&quot;&gt;.&lt;/span&gt;Print lngTest &lt;span style=&quot;Color:gray&quot;&gt;/&lt;/span&gt; &lt;span style=&quot;Color:gray&quot;&gt;4&lt;/span&gt; &lt;span style=&quot;Color:green&quot;&gt;&#039; 3&lt;/span&gt;</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>  Debug&lt;span style=&quot;Color:gray&quot;&gt;.&lt;/span&gt;Print lngTest &lt;span style=&quot;Color:gray&quot;&gt;/&lt;/span&gt; &lt;span style=&quot;Color:gray&quot;&gt;4&lt;/span&gt; &lt;span style=&quot;Color:green&quot;&gt;&#039; 3&lt;/span&gt;</div></td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>  lngTest &lt;span style=&quot;Color:gray&quot;&gt;=&lt;/span&gt; &lt;span style=&quot;Color:gray&quot;&gt;&quot;Max&quot;&lt;/span&gt; <del style="font-weight: bold; text-decoration: none;">        </del>&lt;span style=&quot;Color:green&quot;&gt;&#039; Fehler bei der Zuweisung: Max ist keine Zahl!&lt;/span&gt;</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>  lngTest &lt;span style=&quot;Color:gray&quot;&gt;=&lt;/span&gt; &lt;span style=&quot;Color:gray&quot;&gt;&quot;Max&quot;&lt;/span&gt; <ins style="font-weight: bold; text-decoration: none;">              </ins>&lt;span style=&quot;Color:green&quot;&gt;&#039; Fehler <ins style="font-weight: bold; text-decoration: none;">schon </ins>bei der Zuweisung: Max ist keine Zahl!&lt;/span&gt;</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>  &lt;span style=&quot;Color:green&quot;&gt;&#039; Diese Zeile würde selbstverständlich auch einen Fehler erzeugen, aber er ist schon bei der Zuweisung aufgefallen:&lt;/span&gt;</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>  &lt;span style=&quot;Color:green&quot;&gt;&#039; Diese Zeile würde selbstverständlich auch einen Fehler erzeugen, aber er ist schon bei der Zuweisung aufgefallen:&lt;/span&gt;</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>  Debug&lt;span style=&quot;Color:gray&quot;&gt;.&lt;/span&gt;Print varTest &lt;span style=&quot;Color:gray&quot;&gt;/&lt;/span&gt; &lt;span style=&quot;Color:gray&quot;&gt;4&lt;/span&gt;</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>  Debug&lt;span style=&quot;Color:gray&quot;&gt;.&lt;/span&gt;Print varTest &lt;span style=&quot;Color:gray&quot;&gt;/&lt;/span&gt; &lt;span style=&quot;Color:gray&quot;&gt;4&lt;/span&gt;</div></td></tr> </table> Pwania http://vba-wiki.net/index.php?title=Variant&diff=577&oldid=prev Pwania: /* Nachteile des Variant */ 2019-06-21T17:35:43Z <p><span dir="auto"><span class="autocomment">Nachteile des Variant</span></span></p> <table style="background-color: #fff; color: #202122;" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="de"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Nächstältere Version</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Version vom 21. Juni 2019, 17:35 Uhr</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l44">Zeile 44:</td> <td colspan="2" class="diff-lineno">Zeile 44:</td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>  Debug&lt;span style=&quot;Color:gray&quot;&gt;.&lt;/span&gt;Print varTest &lt;span style=&quot;Color:gray&quot;&gt;/&lt;/span&gt; &lt;span style=&quot;Color:gray&quot;&gt;4&lt;/span&gt;      &lt;span style=&quot;Color:green&quot;&gt;&#039; 3&lt;/span&gt;</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>  Debug&lt;span style=&quot;Color:gray&quot;&gt;.&lt;/span&gt;Print varTest &lt;span style=&quot;Color:gray&quot;&gt;/&lt;/span&gt; &lt;span style=&quot;Color:gray&quot;&gt;4&lt;/span&gt;      &lt;span style=&quot;Color:green&quot;&gt;&#039; 3&lt;/span&gt;</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>  varTest &lt;span style=&quot;Color:gray&quot;&gt;=&lt;/span&gt; &lt;span style=&quot;Color:gray&quot;&gt;&quot;Max&quot;&lt;/span&gt;</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>  varTest &lt;span style=&quot;Color:gray&quot;&gt;=&lt;/span&gt; &lt;span style=&quot;Color:gray&quot;&gt;&quot;Max&quot;&lt;/span&gt;</div></td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>  Debug&lt;span style=&quot;Color:gray&quot;&gt;.&lt;/span&gt;Print varTest &lt;span style=&quot;Color:gray&quot;&gt;/&lt;/span&gt; &lt;span style=&quot;Color:gray&quot;&gt;4&lt;/span&gt;      &lt;span style=&quot;Color:green&quot;&gt;&#039; Fehler bei der Verwendung der Werte!&lt;/span&gt;</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>  Debug&lt;span style=&quot;Color:gray&quot;&gt;.&lt;/span&gt;Print varTest &lt;span style=&quot;Color:gray&quot;&gt;/&lt;/span&gt; &lt;span style=&quot;Color:gray&quot;&gt;4&lt;/span&gt;      &lt;span style=&quot;Color:green&quot;&gt;&#039; Fehler bei der Verwendung der Werte<ins style="font-weight: bold; text-decoration: none;">: Max kann nicht gevierteilt werden</ins>!&lt;/span&gt;</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>Im Vergleich (der Fehler tritt schon bei der Zuweisung auf):  </div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>Im Vergleich (der Fehler tritt schon bei der Zuweisung auf):  </div></td></tr> <tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l52">Zeile 52:</td> <td colspan="2" class="diff-lineno">Zeile 52:</td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>  lngTest &lt;span style=&quot;Color:gray&quot;&gt;=&lt;/span&gt; &lt;span style=&quot;Color:gray&quot;&gt;12&lt;/span&gt;</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>  lngTest &lt;span style=&quot;Color:gray&quot;&gt;=&lt;/span&gt; &lt;span style=&quot;Color:gray&quot;&gt;12&lt;/span&gt;</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>  Debug&lt;span style=&quot;Color:gray&quot;&gt;.&lt;/span&gt;Print lngTest &lt;span style=&quot;Color:gray&quot;&gt;/&lt;/span&gt; &lt;span style=&quot;Color:gray&quot;&gt;4&lt;/span&gt; &lt;span style=&quot;Color:green&quot;&gt;&#039; 3&lt;/span&gt;</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>  Debug&lt;span style=&quot;Color:gray&quot;&gt;.&lt;/span&gt;Print lngTest &lt;span style=&quot;Color:gray&quot;&gt;/&lt;/span&gt; &lt;span style=&quot;Color:gray&quot;&gt;4&lt;/span&gt; &lt;span style=&quot;Color:green&quot;&gt;&#039; 3&lt;/span&gt;</div></td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>  lngTest &lt;span style=&quot;Color:gray&quot;&gt;=&lt;/span&gt; &lt;span style=&quot;Color:gray&quot;&gt;&quot;Max&quot;&lt;/span&gt;        &lt;span style=&quot;Color:green&quot;&gt;&#039; Fehler bei der Zuweisung!&lt;/span&gt;</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>  lngTest &lt;span style=&quot;Color:gray&quot;&gt;=&lt;/span&gt; &lt;span style=&quot;Color:gray&quot;&gt;&quot;Max&quot;&lt;/span&gt;        &lt;span style=&quot;Color:green&quot;&gt;&#039; Fehler bei der Zuweisung<ins style="font-weight: bold; text-decoration: none;">: Max ist keine Zahl</ins>!&lt;/span&gt;</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>  &lt;span style=&quot;Color:green&quot;&gt;&#039; Diese Zeile würde selbstverständlich auch einen Fehler erzeugen, aber er ist schon bei der Zuweisung aufgefallen:&lt;/span&gt;</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>  &lt;span style=&quot;Color:green&quot;&gt;&#039; Diese Zeile würde selbstverständlich auch einen Fehler erzeugen, aber er ist schon bei der Zuweisung aufgefallen:&lt;/span&gt;</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>  Debug&lt;span style=&quot;Color:gray&quot;&gt;.&lt;/span&gt;Print varTest &lt;span style=&quot;Color:gray&quot;&gt;/&lt;/span&gt; &lt;span style=&quot;Color:gray&quot;&gt;4&lt;/span&gt;</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>  Debug&lt;span style=&quot;Color:gray&quot;&gt;.&lt;/span&gt;Print varTest &lt;span style=&quot;Color:gray&quot;&gt;/&lt;/span&gt; &lt;span style=&quot;Color:gray&quot;&gt;4&lt;/span&gt;</div></td></tr> </table> Pwania http://vba-wiki.net/index.php?title=Variant&diff=576&oldid=prev Pwania: /* Vorteile des Variant */ 2019-06-21T17:34:29Z <p><span dir="auto"><span class="autocomment">Vorteile des Variant</span></span></p> <table style="background-color: #fff; color: #202122;" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="de"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Nächstältere Version</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Version vom 21. Juni 2019, 17:34 Uhr</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l21">Zeile 21:</td> <td colspan="2" class="diff-lineno">Zeile 21:</td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>== Vorteile des Variant ==</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>== Vorteile des Variant ==</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>Wenn Sie bei einem Übergabeparameter wahlweise eine Zahl oder eine Zeichenkette erwarten (wie etwa die &#039;Item&#039;-Funktion einer Auflistung), bietet sich der Datentyp &#039;Variant&#039; an.  </div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>Wenn Sie <ins style="font-weight: bold; text-decoration: none;">zum Beispiel </ins>bei einem Übergabeparameter wahlweise eine Zahl oder eine Zeichenkette erwarten (wie etwa die &#039;Item&#039;-Funktion einer Auflistung), bietet sich der Datentyp &#039;Variant&#039; an.  </div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>Bei der Übergabe des Indexes (also einer Zahl) oder des Namens (also einer Zeichenkette) weist VBA der Variablen automatisch den passenden Datentyp zu:  </div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>Bei der Übergabe des Indexes (also einer Zahl) oder des Namens (also einer Zeichenkette) weist VBA der Variablen automatisch den passenden Datentyp zu:  </div></td></tr> </table> Pwania http://vba-wiki.net/index.php?title=Variant&diff=575&oldid=prev Pwania am 21. Juni 2019 um 17:34 Uhr 2019-06-21T17:34:09Z <p></p> <table style="background-color: #fff; color: #202122;" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="de"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Nächstältere Version</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Version vom 21. Juni 2019, 17:34 Uhr</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l1">Zeile 1:</td> <td colspan="2" class="diff-lineno">Zeile 1:</td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>Eine als Variant deklarierte Variable kann einen beliebigen Wert entgegennehmen, inklusive einer Objektreferenz. <del style="font-weight: bold; text-decoration: none;">Wenn Sie bei der Deklaration einer Variablen keinen Datentyp angeben, verwendet VBA automatisch den Datentyp Variant: Dim strString &#039; Wird automatisch als Variant deklariert</del></div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>Eine als Variant deklarierte Variable kann einen beliebigen Wert entgegennehmen, inklusive einer Objektreferenz.  </div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">Wenn Sie bei der Deklaration einer Variablen keinen Datentyp angeben, verwendet VBA automatisch den Datentyp Variant: </ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"></ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">    &lt;span style="Color:blue"> Dim &lt;/span>strText</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">    </ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">    Debug&lt;span style="Color:gray">.&lt;/span>Print VarType&lt;span style="Color:gray">(&lt;/span>strText&lt;span style="Color:gray">)&lt;/span>        &lt;span style="Color:green">' 0 (Empty, Variant-Variable wurde noch nicht verwendet)&lt;/span></ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">    strText &lt;span style="Color:gray">=&lt;/span> &lt;span style="Color:gray">"Text"&lt;/span></ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">    Debug&lt;span style="Color:gray">.&lt;/span>Print VarType&lt;span style="Color:gray">(&lt;/span>strText&lt;span style="Color:gray">)&lt;/span>        &lt;span style="Color:green">' 8 (Zeichenkette)&lt;/span></ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">    strText &lt;span style="Color:gray">=&lt;/span> &lt;span style="Color:gray">15&lt;/span></ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">    Debug&lt;span style="Color:gray">.&lt;/span>Print VarType&lt;span style="Color:gray">(&lt;/span>strText&lt;span style="Color:gray">)&lt;/span>        &lt;span style="Color:green">' 2 (Integer)&lt;/span></ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"></ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">Zum Vergleich: </ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">    &lt;span style="Color:blue"> Dim &lt;/span>strText&lt;span style="Color:blue"> As String&lt;/span></ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">    </ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">    Debug&lt;span style="Color:gray">.&lt;/span>Print VarType&lt;span style="Color:gray">(&lt;/span>strText&lt;span style="Color:gray">)&lt;/span>        &lt;span style="Color:green">' 8 (von Anfang an Zeichenkette)&lt;/span></ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">    strText &lt;span style="Color:gray">=&lt;/span> &lt;span style="Color:gray">"Text"&lt;/span></ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">    Debug&lt;span style="Color:gray">.&lt;/span>Print VarType&lt;span style="Color:gray">(&lt;/span>strText&lt;span style="Color:gray">)&lt;/span>        &lt;span style="Color:green">' 8 (immer noch Zeichenkette)&lt;/span></ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">    strText &lt;span style="Color:gray">=&lt;/span> &lt;span style="Color:gray">15&lt;/span></ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">    Debug&lt;span style="Color:gray">.&lt;/span>Print VarType&lt;span style="Color:gray">(&lt;/span>strText&lt;span style="Color:gray">)&lt;/span>        &lt;span style="Color:green">' 8 (die Ganzzahl wurde automatisch in eine Zeichenkette umgewandelt!)&lt;/span></ins></div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>== Vorteile des Variant ==</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>== Vorteile des Variant ==</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>Wenn Sie bei einem Übergabeparameter wahlweise eine Zahl oder eine Zeichenkette erwarten (wie etwa die &#039;Item&#039;-Funktion einer Auflistung), bietet sich der Datentyp &#039;Variant&#039; an. Bei der Übergabe des Indexes (also einer Zahl) oder des Namens (also einer Zeichenkette) weist VBA der Variablen automatisch den passenden Datentyp zu: Dim varTest As Variant Debug.Print VarType(varTest) &#039; 0 vbEmpty varTest = &quot;Hallo!&quot; Debug.Print VarType(varTest) &#039; 8 vbString varTest = 12 Debug.Print VarType(varTest) &#039; 2 vbInteger</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>Wenn Sie bei einem Übergabeparameter wahlweise eine Zahl oder eine Zeichenkette erwarten (wie etwa die &#039;Item&#039;-Funktion einer Auflistung), bietet sich der Datentyp &#039;Variant&#039; an.  </div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div> </div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>Bei der Übergabe des Indexes (also einer Zahl) oder des Namens (also einer Zeichenkette) weist VBA der Variablen automatisch den passenden Datentyp zu:  </div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div> </div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"> &lt;span style=&quot;Color:blue&quot;&gt;</ins>Dim <ins style="font-weight: bold; text-decoration: none;">&lt;/span&gt;</ins>varTest<ins style="font-weight: bold; text-decoration: none;">&lt;span style=&quot;Color:blue&quot;&gt; </ins>As Variant <ins style="font-weight: bold; text-decoration: none;">&lt;/span&gt;</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"> </ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"> </ins>Debug<ins style="font-weight: bold; text-decoration: none;">&lt;span style=&quot;Color:gray&quot;&gt;</ins>.<ins style="font-weight: bold; text-decoration: none;">&lt;/span&gt;</ins>Print VarType<ins style="font-weight: bold; text-decoration: none;">&lt;span style=&quot;Color:gray&quot;&gt;</ins>(<ins style="font-weight: bold; text-decoration: none;">&lt;/span&gt;</ins>varTest<ins style="font-weight: bold; text-decoration: none;">&lt;span style=&quot;Color:gray&quot;&gt;</ins>)<ins style="font-weight: bold; text-decoration: none;">&lt;/span&gt;          &lt;span style=&quot;Color:green&quot;&gt;</ins>&#039; 0 vbEmpty <ins style="font-weight: bold; text-decoration: none;">&lt;/span&gt;</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"> </ins>varTest <ins style="font-weight: bold; text-decoration: none;">&lt;span style=&quot;Color:gray&quot;&gt;=&lt;/span&gt; &lt;span style</ins>=<ins style="font-weight: bold; text-decoration: none;">&quot;Color:gray&quot;&gt;</ins>&quot;Hallo!&quot;<ins style="font-weight: bold; text-decoration: none;">&lt;/span&gt; </ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"> </ins>Debug<ins style="font-weight: bold; text-decoration: none;">&lt;span style=&quot;Color:gray&quot;&gt;</ins>.<ins style="font-weight: bold; text-decoration: none;">&lt;/span&gt;</ins>Print VarType<ins style="font-weight: bold; text-decoration: none;">&lt;span style=&quot;Color:gray&quot;&gt;</ins>(<ins style="font-weight: bold; text-decoration: none;">&lt;/span&gt;</ins>varTest<ins style="font-weight: bold; text-decoration: none;">&lt;span style=&quot;Color:gray&quot;&gt;</ins>)<ins style="font-weight: bold; text-decoration: none;">&lt;/span&gt;          &lt;span style=&quot;Color:green&quot;&gt;</ins>&#039; 8 vbString <ins style="font-weight: bold; text-decoration: none;">&lt;/span&gt;</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"> </ins>varTest <ins style="font-weight: bold; text-decoration: none;">&lt;span style</ins>=<ins style="font-weight: bold; text-decoration: none;">&quot;Color:gray&quot;&gt;=&lt;/span&gt; &lt;span style=&quot;Color:gray&quot;&gt;</ins>12<ins style="font-weight: bold; text-decoration: none;">&lt;/span&gt; </ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"> </ins>Debug<ins style="font-weight: bold; text-decoration: none;">&lt;span style=&quot;Color:gray&quot;&gt;</ins>.<ins style="font-weight: bold; text-decoration: none;">&lt;/span&gt;</ins>Print VarType<ins style="font-weight: bold; text-decoration: none;">&lt;span style=&quot;Color:gray&quot;&gt;</ins>(<ins style="font-weight: bold; text-decoration: none;">&lt;/span&gt;</ins>varTest<ins style="font-weight: bold; text-decoration: none;">&lt;span style=&quot;Color:gray&quot;&gt;</ins>)<ins style="font-weight: bold; text-decoration: none;">&lt;/span&gt;          &lt;span style=&quot;Color:green&quot;&gt;</ins>&#039; 2 vbInteger<ins style="font-weight: bold; text-decoration: none;">&lt;/span&gt;</ins></div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>== Nachteile des Variant ==</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>== Nachteile des Variant ==</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>Da kein fester Datentyp vorgegeben ist, erfolgt keine Prüfung, ob der zugewiesene Wert dem erwarteten Datentyp entspricht bzw. wird nicht bei der Zuweisung schon eine Umwandlung in den passenden Datentyp versucht. Diese erfolgt gegebenenfalls erst, wenn die Werte weiter verarbeitet wird: Dim varTest As Variant varTest = 12 Debug.Print varTest / 4 &#039; 3 varTest = &quot;Max&quot; Debug.Print varTest / 4 &#039; Fehler! Im Vergleich (der Fehler tritt schon bei der Zuweisung auf): Dim lngTest As Long lngTest = 12 Debug.Print lngTest / 4 &#039; 3 lngTest = &quot;Max&quot; &#039; Fehler! Debug.Print <del style="font-weight: bold; text-decoration: none;">lngTest </del>/ 4</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>Da kein fester Datentyp vorgegeben ist, erfolgt keine Prüfung, ob der zugewiesene Wert dem erwarteten Datentyp entspricht bzw. wird nicht bei der Zuweisung schon eine Umwandlung in den passenden Datentyp versucht.  </div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div> </div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>Diese erfolgt gegebenenfalls erst, wenn die Werte weiter verarbeitet wird:  </div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div> </div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"> &lt;span style=&quot;Color:blue&quot;&gt;</ins>Dim <ins style="font-weight: bold; text-decoration: none;">&lt;/span&gt;</ins>varTest<ins style="font-weight: bold; text-decoration: none;">&lt;span style=&quot;Color:blue&quot;&gt; </ins>As Variant<ins style="font-weight: bold; text-decoration: none;">&lt;/span&gt;</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"> </ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"> </ins>varTest <ins style="font-weight: bold; text-decoration: none;">&lt;span style</ins>=<ins style="font-weight: bold; text-decoration: none;">&quot;Color:gray&quot;&gt;=&lt;/span&gt; &lt;span style=&quot;Color:gray&quot;&gt;</ins>12<ins style="font-weight: bold; text-decoration: none;">&lt;/span&gt;</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"> </ins>Debug<ins style="font-weight: bold; text-decoration: none;">&lt;span style=&quot;Color:gray&quot;&gt;</ins>.<ins style="font-weight: bold; text-decoration: none;">&lt;/span&gt;</ins>Print varTest <ins style="font-weight: bold; text-decoration: none;">&lt;span style=&quot;Color:gray&quot;&gt;</ins>/<ins style="font-weight: bold; text-decoration: none;">&lt;/span&gt; &lt;span style=&quot;Color:gray&quot;&gt;</ins>4<ins style="font-weight: bold; text-decoration: none;">&lt;/span&gt;      &lt;span style=&quot;Color:green&quot;&gt;</ins>&#039; 3<ins style="font-weight: bold; text-decoration: none;">&lt;/span&gt;</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"> </ins>varTest <ins style="font-weight: bold; text-decoration: none;">&lt;span style=&quot;Color:gray&quot;&gt;=&lt;/span&gt; &lt;span style</ins>=<ins style="font-weight: bold; text-decoration: none;">&quot;Color:gray&quot;&gt;</ins>&quot;Max&quot;<ins style="font-weight: bold; text-decoration: none;">&lt;/span&gt;</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"> </ins>Debug<ins style="font-weight: bold; text-decoration: none;">&lt;span style=&quot;Color:gray&quot;&gt;</ins>.<ins style="font-weight: bold; text-decoration: none;">&lt;/span&gt;</ins>Print varTest <ins style="font-weight: bold; text-decoration: none;">&lt;span style=&quot;Color:gray&quot;&gt;</ins>/<ins style="font-weight: bold; text-decoration: none;">&lt;/span&gt; &lt;span style=&quot;Color:gray&quot;&gt;</ins>4<ins style="font-weight: bold; text-decoration: none;">&lt;/span&gt;      &lt;span style=&quot;Color:green&quot;&gt;</ins>&#039; Fehler <ins style="font-weight: bold; text-decoration: none;">bei der Verwendung der Werte</ins>!<ins style="font-weight: bold; text-decoration: none;">&lt;/span&gt;</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div> </div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>Im Vergleich (der Fehler tritt schon bei der Zuweisung auf):  </div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div> </div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"> &lt;span style=&quot;Color:blue&quot;&gt;</ins>Dim <ins style="font-weight: bold; text-decoration: none;">&lt;/span&gt;</ins>lngTest<ins style="font-weight: bold; text-decoration: none;">&lt;span style=&quot;Color:blue&quot;&gt; </ins>As Long<ins style="font-weight: bold; text-decoration: none;">&lt;/span&gt;</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"> </ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"> </ins>lngTest <ins style="font-weight: bold; text-decoration: none;">&lt;span style=&quot;Color:gray&quot;&gt;</ins>=<ins style="font-weight: bold; text-decoration: none;">&lt;/span&gt; &lt;span style=&quot;Color:gray&quot;&gt;</ins>12<ins style="font-weight: bold; text-decoration: none;">&lt;/span&gt;</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"> </ins>Debug<ins style="font-weight: bold; text-decoration: none;">&lt;span style=&quot;Color:gray&quot;&gt;</ins>.<ins style="font-weight: bold; text-decoration: none;">&lt;/span&gt;</ins>Print lngTest <ins style="font-weight: bold; text-decoration: none;">&lt;span style=&quot;Color:gray&quot;&gt;</ins>/<ins style="font-weight: bold; text-decoration: none;">&lt;/span&gt; &lt;span style=&quot;Color:gray&quot;&gt;</ins>4<ins style="font-weight: bold; text-decoration: none;">&lt;/span&gt; &lt;span style=&quot;Color:green&quot;&gt;</ins>&#039; 3<ins style="font-weight: bold; text-decoration: none;">&lt;/span&gt;</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"> </ins>lngTest <ins style="font-weight: bold; text-decoration: none;">&lt;span style=&quot;Color:gray&quot;&gt;=&lt;/span&gt; &lt;span style</ins>=<ins style="font-weight: bold; text-decoration: none;">&quot;Color:gray&quot;&gt;</ins>&quot;Max&quot;<ins style="font-weight: bold; text-decoration: none;">&lt;/span&gt;        &lt;span style=&quot;Color:green&quot;&gt;</ins>&#039; Fehler <ins style="font-weight: bold; text-decoration: none;">bei der Zuweisung</ins>!<ins style="font-weight: bold; text-decoration: none;">&lt;/span&gt;</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div> </div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"> &lt;span style=&quot;Color:green&quot;&gt;&#039; Diese Zeile würde selbstverständlich auch einen Fehler erzeugen, aber er ist schon bei der Zuweisung aufgefallen:&lt;/span&gt;</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"> </ins>Debug<ins style="font-weight: bold; text-decoration: none;">&lt;span style=&quot;Color:gray&quot;&gt;</ins>.<ins style="font-weight: bold; text-decoration: none;">&lt;/span&gt;</ins>Print <ins style="font-weight: bold; text-decoration: none;">varTest &lt;span style=&quot;Color:gray&quot;&gt;/&lt;</ins>/<ins style="font-weight: bold; text-decoration: none;">span&gt; &lt;span style=&quot;Color:gray&quot;&gt;</ins>4<ins style="font-weight: bold; text-decoration: none;">&lt;/span&gt;</ins></div></td></tr> </table> Pwania http://vba-wiki.net/index.php?title=Variant&diff=82&oldid=prev Pwania: Die Seite wurde neu angelegt: „Eine als Variant deklarierte Variable kann einen beliebigen Wert entgegennehmen, inklusive einer Objektreferenz. Wenn Sie bei der Deklaration einer Variablen k…“ 2017-11-23T16:22:22Z <p>Die Seite wurde neu angelegt: „Eine als Variant deklarierte Variable kann einen beliebigen Wert entgegennehmen, inklusive einer Objektreferenz. Wenn Sie bei der Deklaration einer Variablen k…“</p> <p><b>Neue Seite</b></p><div>Eine als Variant deklarierte Variable kann einen beliebigen Wert entgegennehmen, inklusive einer Objektreferenz. Wenn Sie bei der Deklaration einer Variablen keinen Datentyp angeben, verwendet VBA automatisch den Datentyp Variant: Dim strString &#039; Wird automatisch als Variant deklariert<br /> <br /> == Vorteile des Variant ==<br /> <br /> Wenn Sie bei einem Übergabeparameter wahlweise eine Zahl oder eine Zeichenkette erwarten (wie etwa die &#039;Item&#039;-Funktion einer Auflistung), bietet sich der Datentyp &#039;Variant&#039; an. Bei der Übergabe des Indexes (also einer Zahl) oder des Namens (also einer Zeichenkette) weist VBA der Variablen automatisch den passenden Datentyp zu: Dim varTest As Variant Debug.Print VarType(varTest) &#039; 0 vbEmpty varTest = &quot;Hallo!&quot; Debug.Print VarType(varTest) &#039; 8 vbString varTest = 12 Debug.Print VarType(varTest) &#039; 2 vbInteger<br /> <br /> == Nachteile des Variant ==<br /> <br /> Da kein fester Datentyp vorgegeben ist, erfolgt keine Prüfung, ob der zugewiesene Wert dem erwarteten Datentyp entspricht bzw. wird nicht bei der Zuweisung schon eine Umwandlung in den passenden Datentyp versucht. Diese erfolgt gegebenenfalls erst, wenn die Werte weiter verarbeitet wird: Dim varTest As Variant varTest = 12 Debug.Print varTest / 4 &#039; 3 varTest = &quot;Max&quot; Debug.Print varTest / 4 &#039; Fehler! Im Vergleich (der Fehler tritt schon bei der Zuweisung auf): Dim lngTest As Long lngTest = 12 Debug.Print lngTest / 4 &#039; 3 lngTest = &quot;Max&quot; &#039; Fehler! Debug.Print lngTest / 4</div> Pwania