Bloomberg refresh & loop when subroutine exits

[starcraftbud]

Hi,

Its been a while since I've had to use this forum, I wish I could say it was good to be back haha. Stuck on making a loop for a spreadsheet I'm working on.

In a nutshell, I have a list of several ticker symbols. I'm trying to grab the dividend history for each ticker symbol for a specific range. The formula I'm attaching succeeds for the first item on the list. I have to figure out how to make it into a loop that adds the dividend history for the other ticker symbols below columns I-O. The kicker is for the Bloomberg data to refresh, you must exit the subroutine. I think I need to store a named range in the sheet somewhere to be my "i" variable or loop counter. But I'm not very good at that sort of thing and after playing around for a while, I'm stuck. Any help would be much appreciated. I'm attaching the workbook. But the code is this (I realize cell references to I3, M3, etc. might need to be changed):

Please Login or Register  to view this content.

[6StringJazzer]

This thread has been re-posted to Commercial Services. Closed at OP request.