Hi,

Can anybody help me.

When I run the macro on MS Office 2003, it working perfectly fine, but when
I run the macro on MS Office 2007, this error message comes out.
Error Message: Run-time error '1004':
The extract range has a missing or illegal field name.

When I click the debug, it points to Unique:=False.

thanks in advance.