The following works:

Sub test()

D = Range("G2").Value ' Contains A1
E = Range("H2").Value ' Contains B6
Range(D & ":" & E).Select ' Range("A1:B6") is selected

End Sub

HTH

"Momo" wrote:



in addition, yes i have jus realised i left out the"" but this is bringing
up an error when i run the macro,
.Range ("A1:R4") & .Range("D:E").Select

where D and E are as previous and A1 to R4 is a seperate range