• Ask a Question
150
Insert Image Size must be less than < 5MB.
    Ask a Question
    Cancel
    150
    More answer You can create 5 answer(s).
      Ask a Poll
      Cancel
      Participant

      Help need to copy paste data in excel using VBA

      Hi there.. I am very new to VBA, I was trying to paste formula in cell A2 to alternative column cell like – C2,E2,G2 and so on.. can you please help with that

      Asked by vivekagrawal310787 on January 3, 2018 in VBA: Macros.
      1 Answers
      Expert

      Here is a simple copy and paste from cell A1 to D1 using vba

      Sub cpy()
      Range(“A1”).Copy Destination:=Range(“C1”)
      End Sub

      Answered by Hyside2 on January 3, 2018..
      • Sorry that’s  A1 to C1

        on January 3, 2018.
      Cancel
      Add comment