What am I doing wrong here?
I am trying to make clickable cell in 1st sheet,that will take value from next cell (offset 0,1) and add that to a VBA code to retrieve data from Yahoo Finance in 2nd sheet ("Hold").

I get an error [Underlined part] 'cause data can only be retrieved to 1st sheet, and that I don't want. Code is in 1st sheet not in module.


Please Login or Register  to view this content.
Any help would be appreciated.