Originally Posted by
stnkynts
Another thought; If you look at the paramiters of an InputBox.
InputBox(Prompt, Title, Default, Left, Top, HelpFile, HelpContextId, Type)
Look at Type 8. It is a cell reference.
This is actually a better solution from a user interface standpoint because it allows the user to select the cells instead of typing in a range, which could have an error. However, note that the version of InputBox with a Type argument is a method of Application, not the built-in function.
Your code could be written like this:
Bookmarks