Consulting

Results 1 to 2 of 2

Thread: i could not paste the copied data (VBA)

  1. #1

    i could not paste the copied data (VBA)

    Hi,


    Below VBA code is not working. Pls go through it and help me.


    ThisWorkbook.Sheets("sheet1").Range(Cells(2, 4), Cells(2, 7)).Copy Destination:=ThisWorkbook.Sheets("sheet1").Range(Cells(3, 4), Cells(gbplr, 7))

    Note=here "gbplr" means last row in the sheet.

    regards
    syed

  2. #2
        With ThisWorkbook.Sheets("sheet1")
            .Range(.Cells(2, 4), .Cells(2, 7)).Copy Destination:=.Range(.Cells(3, 4), .Cells(gbplr, 7))
        End With

Posting Permissions

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