Prevent Worksheet Function

[AlexanderBB]

         Set iRange = .Range("A100:Z100")
            On Error GoTo Err8 ' handle the error that occurs if there is no cell with comments
            Set Comm = iRange.SpecialCells(xlCellTypeComments)

Comm now contains any Comments (Notes) in row 100
However the 3rd line above runs Private Sub Worksheet_SelectionChange(ByVal Target As Range)

I want to inhibit this so the selection Change event does not run at this time.
Is there an Excel method for that? Or should I just use a global boolean to make it exit?

 

[RoryA]

application.enableevents = false

will disable event code. Remember to ensure it will always get set back to true afterwards.

 

[AlexanderBB]

Great, thank you.