I have forgotten what I did to make this work!

QualityControlQC

New Member
Joined
Sep 2, 2019
Messages
3
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
 

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.
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")
 
Upvote 0
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.
 
Upvote 0

Forum statistics

Threads
1,213,543
Messages
6,114,243
Members
448,555
Latest member
RobertJones1986

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top