Application.CutCopyMode = False clears the clipboard, so that has to be done after the paste.

Excel will also clear the clipboard with the slightest provocation.
So you always want the copy/cut to occur as close as possible to the paste.
So as a test, comment out the line "Selection.AutoFilter Field:=PurchasedWantsColumnNumber"
that occurs immediately after the cut and see what happens.

Also...
the line "Application.CutCopyMode = xlCut can be deleted.
gPurchasedWantsColumn is not declared.
add "Option Explicit" as the first line in the module.

If you still have problems, provide any error messages you receive and where.
Make sure you don't have an "On Error Resume Next" in the code someplace.
--
Jim Cone
Portland, Oregon USA
http://www.mediafire.com/PrimitiveSoftware
(free and commercial excel programs)





"stainless"
wrote in message
...
On Jun 11, 8:18 pm, "Jim Cone" wrote:
Swap these two lines...
Application.CutCopyMode = False
ActiveSheet.Paste

--
Jim Cone

Sorry, still fails on the ActiveSheet.Paste.