PDA

View Full Version : Solved: Named Range Copy



khalid79m
03-25-2010, 10:30 AM
copy and pasting a named range which contains more than once cell of data.

PLease see workbook for full requirments.. Thanks

mdmackillop
03-25-2010, 10:46 AM
Sub DoCopy()
Columns(18).ClearContents
Range("R1") = "Selected Team"
Range(Range("K4")).Copy Range("R2")
End Sub

mdmackillop
03-25-2010, 10:50 AM
If you use this in the Refers To box for Site 1, it will change the size of the range as you add/delete entries

=OFFSET(Sheet1!$A$1,1,0,COUNTA(Sheet1!$A:$A)-1,1)

khalid79m
04-13-2010, 03:59 AM
thanks for you r help