I'm wondering if there's a way to have an inputbox that can either accept a range or a string. I'm making a "Paste to visible Cells" macro, and would like to make interface both simple and useful. If I'm pasting it should be from either a range, or a value that I input, so I'm hoping there's a way to have the same inputbox accept either.
I know I could do this with a form, but would rather not go that route if I can help it.
Bookmarks