<div>
Explain excatly what are you trying to do.<br />
<br />
Are you trying to refresh &quot;Bloomberg&quot; Static links through the VBA?
</div>


Explain excatly what are you trying to do.

Are you trying to refresh "Bloomberg" Static links through the VBA?

<div>
&quot;Are you trying to refresh &quot;Bloomberg&quot; Static links through the VBA?&quot; &nbsp;Yes
</div>


"Are you trying to refresh "Bloomberg" Static links through the VBA?"  Yes

<div>
<div class="content wysiwyg-content">
I am using the below to do a refresh for an application. When I recorded the macro - it had several lines of teh Application.run &quot;RefireBlp&quot; .... but I need to delete those in order to use a button to start the process. &nbsp;My question is - can I shorten as below to do the refresh or do I need to do a loop and if a loop how would I do that?<br />
<br />
&nbsp; &nbsp;Application.Run Range(&quot;TRRefreshCells&quot;)<br />
&nbsp; &nbsp; Application.Run &quot;RefireBLP&quot;<br />
&nbsp; &nbsp; Application.Run Range(&quot;PLRefreshEventHandl<wbr />er&quot;)<br />
&nbsp; &nbsp; Application.Run Range(&quot;TRRefreshCells&quot;)<br />
&nbsp; &nbsp; Application.Run Range(&quot;TRRefreshCells&quot;)<br />
&nbsp; &nbsp; Application.Run Range(&quot;TRRefreshCells&quot;)
</div>
</div>


I am using the below to do a refresh for an application. When I recorded the macro - it had several lines of teh Application.run "RefireBlp" .... but I need to delete those in order to use a button to start the process.  My question is - can I shorten as below to do the refresh or do I need to do a loop and if a loop how would I do that?

   Application.Run Range("TRRefreshCells")
    Application.Run "RefireBLP"
    Application.Run Range("PLRefreshEventHandler")
    Application.Run Range("TRRefreshCells")
    Application.Run Range("TRRefreshCells")
    Application.Run Range("TRRefreshCells")

Application.Run Refresh - need loop?

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.