is there a way to copy just the dimensons of a range, say (a1:a10) and
not the values that range contains to another range, say(c1:c10) in vb?


--
speary
------------------------------------------------------------------------
speary's Profile: http://www.excelforum.com/member.php...o&userid=24959
View this thread: http://www.excelforum.com/showthread...hreadid=385229