insert and copy

  1. T

    Insert Lines Every nth Row

    Hello, I year ago I asked this question and I got a great answer but now I need some help creating a conditional statement within the code: The code below will in its current state insert "x" amount of rows dependent on the specified "row interval." Sub InsertRowsAtIntervals() 'Updateby...
    • traelor
    • Thread
    • blank row loop addition condition formula insert a row insert and copy vba & excel
    • Replies: 0
    • Forum: Excel Questions
  2. M

    Insert and xlDown messed up formatting

    Ok here's the thing I have something like this: When i press second button from the left it executes this code: Private Sub NewPage_Click() Range("A2:P57").Select Selection.Copy Range("A2:D2").Insert Shift:=xlDown, CopyOrigin:=xlFormatFromLeftOrAbove End Sub it simply takes this...
  3. A

    VBA inserting rows then pasting predefined values

    Hi forum, I have cleaned data and removed duplicates, now I need to add 16 pre-defined values (category_locale) for every category_id The category_id's are not always increasing by 1 as some times they will skip sequence. Meaning category_id 3565, should have 16 different...
  4. A

    how to insert row and copy down formula in a Protected Sheet

    Hi, first post on here so please excuse! I am, and have been for quite some time, trying to set up a spreadsheet to be used by a wide range of users (many with very little excel knowledge) which has a great deal of code and formula within it. I have therefore password protected the sheet to...
  5. B

    VBA code: insert and copy line below and add data in two cells

    Hi guys, can one of you genius help me with this: <tbody> postalcode date shift bp destination uom cttc qty factor*QTY produits </tbody> h9h2l6 13/07/3016 1 383 Montreal 383 16...

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