I have a simple macro (below) that invokes the advanced filter criteria
but it fails to refresh if the user is still "in" the filed wher
criteria is being input.

How can I ensure that the data entry field has had an ENTER or TA
pressed before the rest of the macro runs.

Thanks, Simon

Sub mh_apply_filter()
'
' mh_apply_filter Macro
' To allow refresh of the filtering. Macro recorded 27/02/2004 b
administrator
'
'
Range("F10").Select
Range("A10:AB210").AdvancedFilter Action:=xlFilterInPlace
CriteriaRange:= _
Range("C7:C8"), Unique:=False
End Su

--
Message posted from http://www.ExcelForum.com