For Ron de Bruin

[PCOR]

Thanks for the help with the macro:
You said:
You can use something like this

Sub test()
Dim mycell As Range
Set mycell = Application.InputBox( _
prompt:="Select a range", Type:=8)
mycell.Copy Sheets("Sheet2").Range("A1")
End Sub

It worked very well.
What does the TYPE do When canI get more info on this
Thanks

 

[Harald Staff]

Doubleclick the word InputBox and hit F1. If Help is installed that is.

 

[Ron de Bruin]

Hi PCOR

Highlight the word inputbox in your code and press F1