I have a macro that copy/paste special values from a csv file into a excel workbook. After every page it asks me if I want to save the info on the Clipboard. What statement or option can I put into the macro so I don't have to keep clicking NO when the box pops up? Here is part of the macro where I think the code or option needs to go in....I just don't know what it is.....
ActiveWindow.ScrollColumn = 1
Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _
Application.CutCopyMode = False