If cell a1 has the value:
b2:b6
How can I assign rng1 to have this value so that I can give a command.
rng1.select
selection.copy
range("z1").pastespecial xlvalues
Is it something like
set rng1 = range("a1").value
or something along these lines?
--
ianripping
------------------------------------------------------------------------
ianripping's Profile:
http://www.excelforum.com/member.php...fo&userid=3209
View this thread:
http://www.excelforum.com/showthread...hreadid=400731