Using same VBA code in English and German Excel - Expected Function Or Variable
<p>I've created a vba code in the English version of Excel 2016 for Windows.
I've attempted to run the code in a German version of Excel 2011 and 2016 for Mac but both do not work.</p>
<p>I'm getting an error that the <strong>sub function is waiting for a variable or function</strong>.</p>
<p>Trying to debug what the real problem, it seems there are three issues:</p>
<ol>
<li><p><code>IFNA()</code> is not a available function in Excel for Mac - so I had it removed.</p>
</li>
<li><p>I'm using <code>INDEX</code>, <code>MATCH</code> functions. <code>MATCH</code> is translated into <em>VERGLEICH</em> in German Excel and so the function is not recognized.</p>
</li>
<li><p>This line of code is also causing problems, seems like <code>Range().Activate</code> or <code>Range().Select</code> is also not recognized.</p>
<p><code>x = Range(&quot;A&quot; &amp; insert_at).Activate</code></p>
</li>
</ol>
<p>Any ideas or guidance in the last two issues would be very helpful.</p>
<p>Thanks</p>