Help with "Compile Error: Expected: Expression"

[Dan Imal]

Hello all,

I have attached a spreadsheet containing VBA code provided to me by someone I am unable to contact to fix. There are three sections in red that are causing the message "Compile Error: Expected: Expression." The spreadsheet is designed to pull historical data from Yahoo finance for any ticker symbol listed on the sheet tab. I am a total newbie with VBA and Macros, thus hoping someone here will help me correct the code and get the workbook functioning properly. Thanks

[protonLeah]

Your code needs a space between .Sort and the "_"
When the parameters are on separate lines, you need a space and a "_" after the comma:

Please Login or Register  to view this content.

[Dan Imal]

Thanks protonLeah! I was able to correct all the errors based on your advice. Now on to figuring out why its not retrieving the financial data from Yahoo Finance.
If I can't figure that out on my own I may be posting a new thread.