I have forgotten what I did to make this work!

[QualityControlQC]

I have a macro to pull a row of information from a worksheet upon clicking an icon and posting on the sheet with the Icon. Its been a long time since I used this macro and I have forgotten how I made it work. Can someone tell me what is wrong with this macro? It gives me a runtime error of 1004. I am just looking for a quick fix and not to rebuild the whole thing. Thanks for your help.

Range("WeldLog!Print_Area").AdvancedFilter Action:=xlFilterCopy, _
CriteriaRange:=Range("NDE_REQUEST!Criteria"), CopyToRange:=Range("A10:AT10"), Unique:=False

 

[Akuini]

The sheet where Range("A10:AT10") is located must be the active sheet where you run the macro or you can use the sheet as the qualifier, something like sheets("sheet1").Range("A10:AT10")

 

[QualityControlQC]

That is correct. I forgot to mention that the error also says "the extract range has a missing or invalid field name" which makes me think one of my columns got renamed but I copied the columns from the sheet I am receiving data from and pasted them on the sheet I am pasting to which has the macro on it.

 

[Akuini]

So, is it working now?

 

[QualityControlQC]

I am checking the field names right now. Not working yet but will let you know.