Paste a named range to another range in Excel

[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.

[Don Guillett]

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

--
Don Guillett
SalesAid Software
donaldb@281.com
"David Jean" <David Jean@discussions.microsoft.com> wrote in message
news:5E4D7BEB-F01F-4AD4-AFC5-B25B479ECEB0@microsoft.com...
> 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.

[David Jean]

"Don Guillett" wrote:

> Sub getrng()
> Range("a18:c18").Value = Range("crrr").Value 'values
> Range("crrr").Copy Range("a19") 'forumlas
> End Sub
>
> --
> Don Guillett
> SalesAid Software
> donaldb@281.com
> "David Jean" <David Jean@discussions.microsoft.com> wrote in message
> news:5E4D7BEB-F01F-4AD4-AFC5-B25B479ECEB0@microsoft.com...
> > 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.
>
>
>