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
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
Why use a form, you could so it with two simple inputboxes
[vba]
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
[/vba]
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
The think id i want to copy this range in an other sheet on an other workbook
So, you select the other book in that code.
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
Is giving me an error
src.Copy rgt Copy method of Ranges Class Failed
It was tgt