Assign named ranges

[Jos Vens]

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

 

[Norman Jones]

Hi Jos.

Try:

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

 

[keepITcool]

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 :

 

[Jos Vens]

Thanks a lot!

Jos Vens

Hi Jos.

Try:

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


---
Regards,
Norman

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