Hi All,
I want to copy column A, B and F ONLY and not C in new workbook using VBA MAcros.
Can anyone help me?
I am attaching file for reference.
Thanks
Regards
Rishita Mittal
Sub Macro1()
Range("A:B,F:F").Select
Range("F1").Activate
Selection.Copy
Workbooks.Add
ActiveSheet.Paste
Range("A3").Select
Windows("fILE.xlsx").Activate
Application.CutCopyMode = False
Range("A3").Select
End Sub
Sub Macro1()
Range("A:B,F:F").Select
Range("F1").Activate
Selection.Copy
Workbooks.Add
ActiveSheet.Paste
Range("A3").Select
Windows("fILE.xlsx").Activate
Application.CutCopyMode = False
Range("A3").Select
End Sub