• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Copy some cells from one workbook to new workbook.

rishita123

New Member
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
 

Attachments

  • fILE.xlsx
    8.2 KB · Views: 4
Code:
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

hi @rishita123
if is it Okey?
 
Hi !​
Can anyone help me?
As you forgot to explain the expected layout or to attach the expected result workbook but you can start yourself​
just activating the Macro Recorder and operating manually like rahulshewale1 did instead of only 2 necessary codelines …​
 
Back
Top