insertion

  1. M

    complexe insertion messes up the formulas

    Hello everyone, I am having a hard time figuring out how to deal with a too zealous characteristic of Excel… I am programming a macro that is basically just an advanced insertion : instead of just copying and inserting a range of cells, I want to allow the user to modify a certain number of...
  2. N

    How does subtotal formula updates automatically with insertion of new rows?

    I have subtotal formulas at different rows of columns I. That is at I15 (I9:I14), I18(I16:17), I32(I19:I31). when I insert a new row, the formula at I15 updated to accommodate the new cell however the formulas in I18 an I32 resist t change for any new insertion between the range and the formula...
  3. B

    Insertion of rows up to the date of retirement

    How can I insert rows automatically up to the date of retirement in the case given in the link:https://drive.google.com/file/d/1D_vjMb6vhozjY0av8jyMAt5Q70OawnhU/view?usp=drivesdk
  4. E

    VBA for Auto insertion of serial numbers

    Hi I need a VBA code for auto insertion of the Serial number in column A when entry in Column B Than you
  5. K

    Offsetting column insertion following user input VBA

    Hi all, Following my recent post, I have the following code (inserting a column using a user input) that works: (Code) colLetter = InputBox("Please enter replication factor column:", "Factor column") Columns(colLetter).Insert Shift:=xlToRight, CopyOrigin:=xlFormatFromLeftOrAbove (/Code)...
  6. E

    VBA Macro to insert rows when the following condition is met

    Hello Forum, I'm trying to write a conditional macro where VBA will add (x) number of rows depending on how many separate numbers appear in a specific cell. However, I just discovered VBA and I can't find any postings that specifically address this scenario. I don't know if it can be done...

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