Paste a named range to another range in Excel

D

David Jean

I'm trying to wean one of our employees off Lotus 123. He wants to be able to
paste/insert a range of cells that have been previously defined/named without
having to go and copy it first. We are using Office 2003.
 
D

Don Guillett

Sub getrng()
Range("a18:c18").Value = Range("crrr").Value 'values
Range("crrr").Copy Range("a19") 'forumlas
End Sub
 
Top