hi,
i m unable to paste the row to the new sheet here is the code below:
![]()
Sub last_row_column() Dim lastRow As Integer Range("B1000000").End(xlUp).EntireRow.Copy Worksheets("MasterSheet").Activate ActiveWorksheets.Cells(lastRow + 1, 1).PasteSpecial
in this i have search for the last row filled
the row is then copied
the issue is that i have to paste it to the sheet naming "MasterSheet" but i m unable to do this.
please help.
Bookmarks