RE: How do I make a section sort automatically?

Giganews Newsgroups
Subject: RE: How do I make a section sort automatically?
Posted by:  Gary''s Student
Date: Fri, 19 May 2006

If the section is A1 thru C10 (no headers), then enter the following in
worksheet code:

Sub Worksheet_Change(ByVal Target As Excel.Range)
If Intersect(Range("A1:C10"), Target) Is Nothing Then Exit Sub
Application.EnableEvents = False
Range("A1:C10").Sort Key1:=Range("A1")
Application.EnableEvents = True
End Sub

This will cause automatic re-sort (using column A as the key) after the data
has been updated.

--
Gary''s Student

"Wicus" wrote:

> I want a section to sort itself automatically when the information is updated

Replies

None

In response to

How do I make a section sort automatically? posted by Wicus on Fri, 19 May 2006