Thread: Copy to Named Range
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
FIRSTROUNDKO via OfficeKB.com FIRSTROUNDKO via OfficeKB.com is offline
external usenet poster
  
Posts: 65
Default Copy to Named Range
I can "Set Range" then "Copy" then "select" then paste as below

If Cells(CCC - 1, 1).Value = Cells(CCC, 1).Value Then
Set MyRange = Cells(CCC, 100).End(xlToLeft).Offset(0, 1)
Range(Cells(CCC - 1, 11), Cells(CCC - 1, 14)).Copy
MyRange.Select
ActiveSheet.Paste

For speed I do not want donot want to select but the following code errors
out

Range(Cells(CCC - 1, 11), Cells(CCC - 1, 14)).Copy Range(Myrange)

--
Message posted via http://www.officekb.com

Reply With QuoteReply With Quote