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