Quote:
Originally Posted by Aquinax
Yeah, but I wouldn't even know what makes Excel behave one time this way (first row of data treated as part of data) and at another time differently (i.e. the first row is regarded as header).
|
Testing this code it automatically assigns the first row as header and does not prompt you. Assign this macro to a button. Then select the header and run the macro. It should display just the unique records. Let me know what you think or if you want code that will automatically copy and paste it to a new location.
Code:
Sub UniqueFilter()
' Code to automatically select entire list of data
' and advance filter the unique records in place.
Range(Selection, Selection.End(xlDown)).Select
Selection.AdvancedFilter Action:=xlFilterInPlace, Unique:=True
End Sub
08-10-2013, 05:16 PM
Similar Threads
Selecting blank cells in criteria
Windows 7 64bit 
Office 2003
Threaded Mode