Advanced Filter - extract range missing or invalid field name

[sorensjp]

Hi all,

I'm unable to debug

Run-time error '1004':
The extract range has a missing or invalid field name.

Please Login or Register  to view this content.

I'm running an Advance filter on/in Sheet 2 ('ACT_MEM') and placing the Filtered Data on Sheet 9 (WEAPS_QUAL_RPTS). What am I missing here? The code with the bug is located on the 'Weaps_RPT_Misc' Module called Sub WeaponsRpt_Table(). I'm not seeing where my error is. I have copied the Headers and Pasted for the Advanced Filter.

V/r,
Jim

[Fluff13]

Try

Please Login or Register  to view this content.

[bakerman2]

If I understand correctly.

[sorensjp]

bakerman2,

I thank you again! I realized I had and the wrong columns in the sheet3. You made me realize the range I had set to find the LastRw was incorrect too. The attached file is the what I wanted to see happen. The 'WEPS_QUALS_RPT' is the finished product for this portion of the project. Now, it back to figuring out the Advanced Filter issues on the 'Events' Sheet (not in this file).

Advanced Filters are fast and really make this application quick.


Thank you for your assistance, again .


V/r,
Jim

[bakerman2]

You're welcome and thanks for rep+.

[sorensjp]

bakerman2,

Thank you for your assistance.

V/r,

Jim