Copy The Data from Source To Destination
Copy The Data from Source To Destination With In the Workbook
Sub Copy_The_Data_With_In_Coding_Workbook()
Set wkb = ActiveWorkbook
Dim SrcRng As Range
Set SrcRng = Application.InputBox("Select The Source Range To Copy", "www.Tricks12345.com", Type:=8)
Dim DestRng As Range
Set DestRng = Application.InputBox("Select The Destination Range To Paste", "www.Tricks12345.com", Type:=8)
SrcRng.Copy DestRng
End Sub