close
I want a section to sort itself automatically when the information is updated
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(quot;A1:C10quot;), Target) Is Nothing Then Exit Sub
Application.EnableEvents = False
Range(quot;A1:C10quot;).Sort Key1:=Range(quot;A1quot;)
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 Studentquot;Wicusquot; wrote:
gt; I want a section to sort itself automatically when the information is updated
全站熱搜
留言列表
