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 Contributor Last seen December 27, 2022 - May 9, 2017 at 11:12 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Contributor 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 word - Guide
- Saints row 2 cheats - Guide
- How to copy paste youtube link on android - Guide
- The following excel image has a vba program (see below). what will be the result after the program is executed? any cells not displayed are currently empty, and any cells with numbers are formatted numeric. sub afdo a=0 lastrow = cels(rows. count, 1). end(xdup). row for i =14 to lastrow step 2 a=a cellsii. 5) value next cells(lastrow 2, 1) value = "the sum - Guide
- 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 named ranges. ✓ - Excel Forum
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Contributor
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