paste row

  1. Rijnsent

    Macro speed - copy/paste rows

    Hi all, I'm working on a macro where I have to swap around some rows on a sheet. So I've added some grouping labels in column B, loop though my 150 rows and move blocks in a certain order. Moving means: cut and paste at the top. Roughly speaking, this is what I'm doing (option Explicit is on)...
  2. M

    Insert row under selected row and paste ONLY formulas and Conditional formating

    Hello, I need insert row under selected row, copy formulas and conditional and paste to new row. Can you someone modify this macro what i found. It copy all and works werry good, but insert also text. Private Sub cmdInsertRow_Click() Dim lRow As Long Dim lRsp As Long On Error...
  3. M

    Copy row to sheets if cell in col A=sheetname

    Hi- Been all over the web today and in this forum, and so close, but no cigar. I need to copy a row from "Master" sheet to other named sheets in one workbook, based upon CellValue Col A = sheet name. Continue down col A, copying the row to the appropriate sheet (jumping to End.xlUp.offset1 of...
  4. E

    Copy and paste a row

    Hello people, I need help with a code that copy the first row from the sheet sheetname"test" and put it on row 1 into the sheetname "Statistics" Could someone help me? Thank you in advance

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top