sORTING

M

MASSIVE

Hi i want to auto sort a league range C4:G19, i have tried the auto sort routine:- Private Sub Worksheet_Change(ByVal Target As Range
If Not Intersect(Target, Range("C4:G19")) Is Nothing The
Range("C4:G19").Sort Key1:=Columns("G"
End I
End Su

Which works ok if i input the figures into the league, but the league is updated from a seperate sheet using the IF command, but the league doesnt auto sort from a seperate shee

Any clues please
 
D

Dave Peterson

I think it would kind of drive me nuts to have it sort automatically (I run your
macro on demand.)

But try putting your sort statements into the worksheet_calculate event and see
if you like it.
 
Top