AllowEditRanges.Add troubles
<p>I am having trouble with AllowEditRanges. The following code is correct for a range from a1 to g1:</p>

<pre><code>Dim ws As Worksheet
Set ws = Application.ActiveSheet
ws.Unprotect
ws.Protection.AllowEditRanges.Add Title:="Classified", Range:=Range("A1:G1"), Password:="pw"
ws.Protect
</code></pre>

<p>The second I change the range into <code>Range:=Range("$A:$G;$I:$O")</code> I get the following error:</p>

<p>Error 1004: Method Range object _global failed  (sorry for the translation)</p>

<p>Any help will be appreciated. </p>