how to write code for the following requirement

[Arshicw]

say cell A2 having value of B5 ( this B5 is a cell address)

cell A6 having value of C10 ( this c10 is a cell address)

Private Sub CommandButton1_Click()
ActiveSheet.Range("A2:A6").Copy
End Sub


Here in the code there will be A2 and A6 only as their cell value represents my desired value

Now i want to write a code so that the above should copy the range from B5 : C10 .

Thank you in advance

 

[My Aswer Is This]

Try this:

Sub Copy_Me()
Dim ans As String
Dim anss As String
ans = Range("A2").Value
anss = Range("A6").Value
ActiveSheet.Range(ans & ":" & anss).Copy
End Sub