Hi Guys

Basically i just want a range which is not set, but can be defined by 2 inputboxes (one for the (X:y) coordinate and one for the (x:Y) coordinate and then automatically get selected.

heres my code so far. i just can not define the range through those inpboxes....

[VBA]Dim x As String
Dim y as String

x = InputBox("please enter first range coordinate")
y = InputBox("please enter 2nd range coordinate")

copyrange = (x:y) 'this is, where it doesnt work)


With Worksheets("sheet1")
copyrange.Select
End With[/VBA]

it must be possible somehow....thanks for having a look, guys!

cheers

ben