When I run the following macro by selection of a cell within the range, the macro does not run until I select any other cell after selecting that cell. Is there any way to have the macro run immediately with selection of the cell in the range? Thanks for any help you can provide.
Code:
Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Target, Range("C2:C100")) Is Nothing Then
Exit Sub
Else
RunBTSlong
End If
End Sub
Last edited by a moderator: