- Sep 29, 2014
I have the following VBA which copies a dynamic range. However, I want to clear the marching ants, but retain the clipboard so I can paste into another application. Can anyone assist?
Sub CopyData() Dim a As Integer a = Sheets("Classification").Range("A" & Rows.Count).End(xlUp).Row Sheets("Classification").Range("A1:I" & a).Copy Application.CutCopyMode = True ActiveSheet.Range("A2").Select End Sub