PDA

View Full Version : i could not paste the copied data (VBA)



syed_iqbal
04-22-2017, 07:38 PM
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

rlv
04-22-2017, 10:10 PM
With ThisWorkbook.Sheets("sheet1")
.Range(.Cells(2, 4), .Cells(2, 7)).Copy Destination:=.Range(.Cells(3, 4), .Cells(gbplr, 7))
End With