<div>
Try thus:
<pre><code id="code-20-36925966-1">basewks.Range(&quot;A1&quot;).CurrentRegion.Name = &quot;Ranges&quot;</code></pre>
</div>


Try thus:

basewks.Range("A1").CurrentRegion.Name = "Ranges"

<div>
Perhaps you can get in the habit of testing things before you ask the question.
</div>


Perhaps you can get in the habit of testing things before you ask the question.

<div>
<div class="content wysiwyg-content">
<pre><code id="code-10-27383962-1">Set BaseWks = ActiveSheet

Sheets(&quot;GL Summary&quot;).Range(&quot;A1:G&quot;).CurrentRegion.Name = &quot;Ranges&quot;</code></pre>
<br />
Hi,<br />
<br />
I am getting the 'Application Defined or Object defined error' on above line.<br />
<br />
Using examples in this forum, I tried this<br />
<br />

<pre><code id="code-10-27383962-2">Set BaseWks = ActiveSheet

basewks.Range(&quot;A1:G&quot;).CurrentRegion.Name = &quot;Ranges&quot;</code></pre>
<br />
Then it gave me, 'method range of object worksheet failed' error :o<br />
<br />
Any help is much appreicated!<br />
I am trying to assign the region as an array for my dynamic pivot table!<br />
<br />
Thanks!<br />
<br />
<br />

</div>
</div>


(CODE)

Hi,

I am getting the 'Application Defined or Object defined error' on above line.

Using examples in this forum, I tried this

(CODE)

Then it gave me, 'method range of object worksheet failed' error :o

Any help is much appreicated!
I am trying to assign the region as an array for my dynamic pivot table!

Thanks!




Application Defined or Object defined error

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.