Assign named ranges
 

Hi,

can someone tell me if it is possible to assign a named range to another
with the same dimension

eg. [aValue]=[aResult] where [aValue] is the named range [A1:A3] and
[aResult] is the named range [B1:B3]

thanks
Jos Vens

Assign named ranges
 

Hi Jos.

Try:

Range("aValue").Value = Range("aResult").Value


---
Regards,
Norman



"Jos Vens" wrote in message
...
Hi,

can someone tell me if it is possible to assign a named range to another
with the same dimension

eg. [aValue]=[aResult] where [aValue] is the named range [A1:A3] and
[aResult] is the named range [B1:B3]

thanks
Jos Vens

Assign named ranges
 

Jos..

I always liked this [a1:d3] referencing.
I've stopped using it since Tom Ogilvy recently pointed me to:

Square Bracket Notation Is Less Efficient Than Tunneling
<http://support.microsoft.com/default.aspx?scid=kb;en-us;104502


--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


Jos Vens wrote :

Hi,

can someone tell me if it is possible to assign a named range to
another with the same dimension

eg. [aValue]=[aResult] where [aValue] is the named range [A1:A3] and
[aResult] is the named range [B1:B3]

thanks
Jos Vens

Assign named ranges
 

Thanks a lot!

Jos Vens

"Norman Jones" schreef in bericht
...
Hi Jos.

Try:

Range("aValue").Value = Range("aResult").Value


---
Regards,
Norman



"Jos Vens" wrote in message
...
Hi,

can someone tell me if it is possible to assign a named range to another
with the same dimension

eg. [aValue]=[aResult] where [aValue] is the named range [A1:A3] and
[aResult] is the named range [B1:B3]

thanks
Jos Vens