Read this also

Important:
1) Always use unique headers in the first row of your data table
2) Don't use empty rows in your data table
3) Have an empty row above, below and a empty column next to your data table
4) Don't use merged cells in your table


--
Regards Ron de Bruin
http://www.rondebruin.nl


"GregR" wrote in message oups.com...
Ron, I am using your macro and get an error message on the line:

rng.Columns(29).AdvancedFilter _
Action:=xlFilterCopy, _
CopyToRange:=.Range("IV1"), Unique:=True

Columns(29) or "AC" is the last column in my currentregion and the
header row is "AC4". What do I change to make this work? TIA

Greg