could you instruct me where/how to place that code?
"Dave" wrote in message
...
I will try...thanks...
"Sunil Jayakumar" <sunil.jayakumar[at]gmail.com wrote in message
...
You could try the worksheet change event:
Private Sub Worksheet_Change(ByVal Target As Range)
<<Sort Code
End Sub
This should re-sort your selection everytime the worksheet changes.
Hope this helps
Sunil Jayakumar
"Dave" wrote in message
...
Is there any way to make a dated entry insert itself in the worksheet in
the correct order without doing a sort operation, or inserting a new
row?
would be a big help for my reservations workbook
thanks
D
www.ayyoo.com/poker.html