A macro to copy/paste a cell and other cells in the same row
Solved/Closed
tanja20
-
May 5, 2017 at 07:39 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - May 9, 2017 at 11:12 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - May 9, 2017 at 11:12 AM
Related:
- A macro to copy/paste a cell and other cells in the same row
- How to delete a row in a table in word - Guide
- Saints row 2 cheats - Guide
- Excel macro to create new sheet based on value in cells - Guide
- Insert a function in cell b2 to display the current date from your system. ✓ - Excel Forum
- Insert a new sheet at the end of the tab names and paste the range names starting in cell a1. autofit columns a:b and name the worksheet as range names. ✓ - Excel Forum
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
May 8, 2017 at 11:20 AM
May 8, 2017 at 11:20 AM
Hi Tanja,
You can't paste an entire row in column B, it won't fit. You will need to adjust:
FoundCells.EntireRow.Copy Destination:=cell.Offset(0, 1)
into maybe:
range(cells(foundcells.row,"B"),cells(foundcells.row,"C")).copy cell.offset(0,1)
Best regards,
Trowa
You can't paste an entire row in column B, it won't fit. You will need to adjust:
FoundCells.EntireRow.Copy Destination:=cell.Offset(0, 1)
into maybe:
range(cells(foundcells.row,"B"),cells(foundcells.row,"C")).copy cell.offset(0,1)
Best regards,
Trowa
May 9, 2017 at 11:05 AM
thank you very much for your tip. It works now!
Best regards,
Tanja
May 9, 2017 at 11:12 AM