Hello, I am working on a project where I need to have the user select a range and pass that to my macro. It seems like the best way to do this is through the application.inputbox method, however it seems like excel does not even know that this method exits. Every time I try to use it, I get a compile error, "Method or data member not found".

Below is a sample code that generates the error for me:

Sub test()

Dim rng As Range

Set rng = Application.InputBox( _
      Title:="Select Test Report", _
      Prompt:="Select the row of the test report you want to copy", _
      Type:=8)

End Sub
I have not been able to find any similar issues through searching online. I'm guessing that I may need to add in a reference library, but haven't found any information on which one would be needed.

For reference, the VBA inputbox works fine, however that one does not have the "Type" argument to allow a range to be selected. If anyone has any thoughts on this, I would greatly appreciate it!

Thank you for your help.