Copy and Paste Named Range data in one sheet to another sheet

[Karthicdasari]

HI , I want to copy and paste Data of named range from one sheet to another sheet. To explain it more... There is Named range "ABC" in one sheet having 5 rows and 5 columns of data. Now i want same data of "ABC" to display in sheet 2.

Can anybody help me on this please....

 

[VoG]

Try like this

Sub Cpy()
Sheets("Sheet1").Range("ABC").Copy Destination:=Sheets("Sheet2").Range("A" & Rows.Count).End(xlUp).Offset(1)
End Sub

 

[Karthicdasari]

Thank You Very much VOG.

Can we do the same through any Excel formulas ....rater than VBA code..?

 

[VoG]

I don't think that is possible with a formula.