<div>
Set currRange = ActiveSheet.Range(&quot;List1&quot;)<wbr /><br />

</div>


Set currRange = ActiveSheet.Range("List1")


<div>
Nickman87,<br />
<br />
With object variables, you must use the Set statement.<br />
<br />
Regards,<br />
<br />
Patrick
</div>


Nickman87,

With object variables, you must use the Set statement.

Regards,

Patrick

<div>
I tried this now :<br />
&nbsp; &nbsp; Dim currRange As Object<br />
&nbsp; &nbsp; Set currRange = ActiveSheet.Range(&quot;List1&quot;)<wbr /><br />
<br />
Still with no succes. I keep on getting the same error on the same spot.
</div>


I tried this now :
    Dim currRange As Object
    Set currRange = ActiveSheet.Range("List1")

Still with no succes. I keep on getting the same error on the same spot.

<div>
The error I get is this (in dutch):<br />
&nbsp; &nbsp; &nbsp; &nbsp; Door de toepassing of het object gedefinieerde fout<br />
Wich is something like this in English:<br />
&nbsp; &nbsp; &nbsp; &nbsp; Error defined by the application or the object<br />
<br />
So, what this actually means is that the object (I guess) is throwing me an Error (for some reason...)<br />
<br />
I am sure the name &quot;List1&quot; exist, but could it be a problem that it is defined in two sheets?<br />
<br />
Kind regards,<br />
Nick
</div>


The error I get is this (in dutch):
        Door de toepassing of het object gedefinieerde fout
Wich is something like this in English:
        Error defined by the application or the object

So, what this actually means is that the object (I guess) is throwing me an Error (for some reason...)

I am sure the name "List1" exist, but could it be a problem that it is defined in two sheets?

Kind regards,
Nick

<div>
I found the problem...<br />
Apparently the Range was not defined... I just tried on another computer and here the range does not exist...<br />
<br />
Thanks for you help!
</div>


I found the problem...
Apparently the Range was not defined... I just tried on another computer and here the range does not exist...

Thanks for you help!

<div>
<div class="content wysiwyg-content">
I'm writing an Excel 2007 macro and I want to select a certain range from my active worksheet.<br />
<br />
I tried using this:<br />
&nbsp; &nbsp; currRange = ActiveSheet.Range(&quot;List1&quot;)<wbr /><br />
<br />
But I get the error number 1004 on this line.<br />
I just can't figure it out...
</div>
</div>


I'm writing an Excel 2007 macro and I want to select a certain range from my active worksheet.

I tried using this:
    currRange = ActiveSheet.Range("List1")

But I get the error number 1004 on this line.
I just can't figure it out...

Excel range from active sheet

Networking hardware includes the physical devices facilitating the use of a computer network. Typically, networking hardware includes gateways, routers, network bridges, modems, wireless access points, networking cables, line drivers, switches, hubs, and repeaters. But it also includes hybrid network devices such as multilayer switches, protocol converters, bridge routers, proxy servers, firewalls, network address translators, multiplexers, network interface controllers, wireless network interface controllers, ISDN terminal adapters and other related hardware.

Networking Hardware-Other

VBScript (Visual Basic Scripting Edition) is an interpreted scripting language developed by Microsoft that is modeled on Visual Basic, but with some important differences. VBScript is commonly used for automating administrative and other tasks in Windows operating systems (by means of the Windows Script Host) and for server-side scripting in ASP web applications. It is also used for client-side scripting in Internet Explorer, specifically in intranet web applications.

VB Script

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