revise macro to use cell reference

[adnan buran]

hi all,


I have the code below:


Sub Macro1()
'
' Macro1 Macro
' Macro recorded 15/01/2004
'

Workbooks.Open Filename:= "Book2.xls"
Range("A:B").Copy Destination:=Workbooks("Book1").Range("A:B")
Windows("Book2.xls").Close
MsgBox ("Completed Copying")
End Sub


I want to revise this macro, so that instead of Range(A:B), it will get the range from a cell (let's say from A1). So if the value in A1 is E:F, then range E:F is copied ..etc

many thanks,