<div>
so simple but effective thank you
</div>


<div>
<div class="content wysiwyg-content">
I have an update routine that runs a number of subs that update various cells, however, the update is triggering:<br />
Public Sub Worksheet_SelectionChange(<wbr />ByVal Target As Excel.Range)<br />
<br />
I dont want that to run while i am updating, I only wanted to use it after the cells were populated.<br />
<br />
how do i achieve this?
</div>
</div>


I have an update routine that runs a number of subs that update various cells, however, the update is triggering:
Public Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)

I dont want that to run while i am updating, I only wanted to use it after the cells were populated.

how do i achieve this?

excel selectionchange clashing with data update

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