vba with bloomberg links
Hello,
When I use the code ActiveCell.FormulaR1C1 = "=blp(blabla)" The cell is populated with the data only after the whole macro is finished. I do a cut and paste by values with the populated cells to tinker with the data, but because the data is not loaded until the macro is done running, i only get a bunch of #N/As for my values. Is there a way to keep the macro from proceeding until it is certain that all the cells with formulas have been populated with actual data? thank you/ |
All times are GMT +1. The time now is 08:22 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com