I have the code in VBA.xlsm (Macro1) to get data prices of the stock mmm with the URL in the code. This macro gets data into Cell A2 with code: Destination:=Cells(2, 1).
I must do it, 496 times to get data prices for each stock :
+ With Cell A2, Data Prices for mmm.
+ With Cell H2, Data Prices for abt.
+ With Cell O2, Data prices for ....
If I create 496 macros (or within 496 With ... End With Statements) like this, I will waste very much time. I want to do it with only 1 macro (or only 1 With ... End With Statement).
Now, I can do as follows in VBA.xlsm (Macro2) to get data prices of the stock mmm into all Cells: A2, H2, O2 ... with Loops: For ... Next.
If you understand my case, please help me.