I have a simple input box line that's supposed to let me select cells from a range:
Set rng = Application.InputBox(Prompt:="Select the Range whose formats you want to specify.", Type:=8)
When I run the input box, I can't select any cell from any workbooks or any worksheets and its super annoying. I'm not sure why!
Any ideas here?