Userform select and copy

[teodormircea]

Hello

I would like to make an userform to chose a range of values in a sheet and then chose an other sheet from an othe workk bokk and copy the values

[Bob Phillips]

Why use a form, you could so it with two simple inputboxes


Set src = Application.Inputbox("Select range to copy FROM with mouse",Type:=8)
Set tgt = Application.Inputbox("Select first cell of range to copy TO with mouse",Type:=8)
If Not src Is Nothing And Not tgt Is Nothing Then
src.Copy rgt
End IF

[teodormircea]

The think id i want to copy this range in an other sheet on an other workbook

[Bob Phillips]

So, you select the other book in that code.

[teodormircea]

Is giving me an error

src.Copy rgt Copy method of Ranges Class Failed

[teodormircea]

It was tgt