sORTING

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Is it possible have a message ( visual or Audio ) when the Curser is place in a cell? 4
Automatic sort macro 2
Junp start my Select Case Macro 12
Sorting table automatically 13
auto sort macro 1
Excel How to run multiple Private Sub Worksheet_Change(ByVal Target As Range) 0
sorting a range 2
Ron de Bruin - Merge cells from all worksheets 0

Back
Top