I have this bit of code which I use to select a range which I then use in a larger bit of code.....

On Error Resume Next
Dim Message4, Title4, Default4
Message4 = "Select range to which you would like to add data."
Title4 = "Data Add Range"
Default4 = ""
Set Rng4 = Application.InputBox(Message4, Title4, Default4, Type:=8)
If Rng4 Is Nothing Then Exit Sub

It works great! However, I can't select a range from another workbook. That is, from a workbook which doesn't contain this code. That workbook is going to be different everytime I run the code. What I ultimately want to do is create an addin where I can compare data is 2 different workbooks.

Any help would be great.