Paste a named range to another range in Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Sub getrng()
Range("a18:c18").Value = Range("crrr").Value 'values
Range("crrr").Copy Range("a19") 'forumlas
End Sub
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA - retrieve data on last create named range from previous inserted named range 0
Excel Limit to Named Ranges 1
Named range list 2
Can't located named range 3
VBA Code- Copy & Paste in Blank Range 9
3D Named Range 4
Editing a Range 2
Relative Range Selection & Paste 2

Back
Top