Cells A1:A20 contains Bloomberg BDH data. I'm looking for a way to copy-paste the entries of those cells in a different sheet.And then replacing the values with a BDH call.
This process is going to be looped for a large number of times, say 1500.
(Thus making it very ineffective to use a Application.OnTime Now command)
Any suggestions?