Consulting

Results 1 to 2 of 2

Thread: column to be cut and pasted with values in different column

  1. #1
    VBAX Regular
    Joined
    Nov 2012
    Posts
    24
    Location

    Question column to be cut and pasted with values in different column

    Dear Team,

    Now here i wanted entire "BO" column to be cut and pasted with values in " A" column in the same sheet .

    Here is the code that i have used but it's not happening properly

    Range("BO1").Select 
    Range(Selection, Selection.End(xlDown)).Select 
    Selection.Cut 
    Range("BO1").Select 
    Selection.End(xlToLeft).Select 
    Columns("A:A").Select 
    Columns("A:A").Select 
    Selection.Insert Shift:=xlToRight 
    Selection.Copy 
    Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ 
    :=False, Transpose:=False  Application.CutCopyMode = False
    



  2. #2
    VBAX Regular
    Joined
    Nov 2012
    Posts
    24
    Location
    Hi Team,

    Can you please help me on this request ?

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •