If then statement to control when the script runs

Hi,

I have a small problem, I have a script in worksheet change sub, However I added a piece to sort the columns. Is there a way I can have the sort not take place till after the data is entered into range "B"

As it is now the script runs as soon as the users enters anything in range "A"

Thank You, Mike

Please Login or Register  to view this content.

'This line returns TRUE whenever anyone enters anything in Column A or B
If Not Application.Intersect(Me.Range("A5:B100"), Target) Is Nothing Then
'This line return TRUE whenever anyone enters anything in Column B Only
If Not Application.Intersect(Me.Range("B5:B100"), Target) Is Nothing Then