I'm using an array to pull stock info. Part of this array is for a stock symbol.
I'm trying to see if it is possible to assign cell A1 for that piece of the array so I can change the symbol bytyping a new symbol in A1. If so I would create a macro and assign it to a button to handle ctrl+Shift+enter.
Do I have any other options if this isn't going to work?
Bookmarks