insert rows

  1. A

    maro, insert rows where rows determined by number of carriage returns

    The best way to explain my problem is to look at the table below: <TABLE style="WIDTH: 348pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=464><COLGROUP><COL style="WIDTH: 87pt; mso-width-source: userset; mso-width-alt: 4242" span=4 width=116><TBODY><TR style="HEIGHT...
  2. KP_SoCal

    VBA to trigger an event on Insert Rows

    I’m using Excel 2007, and I would like to trigger the sub routine listed below when a user attempts to insert a row(s). I’m guessing it would have to be fired on a “Worksheet Change” event. So the logic might go something like, after rows are inserted then Application.Undo (this would undo the...
  3. G

    Select column to evaluate

    I need help modifying the code below. I know this should be easy but I have very little experience with VBA. What I want to do is change the code to evaluate a column with the header "jobnbr" instead of “column A” in my worksheet. The column may change locations in my worksheet but the header...
  4. Z

    VBA to insert rows

    I'm working with Excel 2003. I need to insert 2 blank rows within a spreadsheet above certain other rows that contains data that starts with a particular text string. Details: Column A has office codes in the form of "0301A", "0301B", etc. Column F will have billing codes that could start...
  5. M

    Insert rows - Limiting to a specific Range

    I'm using code from David Ritchie's website. This works fine Sub InsertNewRow() Dim vRows As Long ' row selection based on active cell -- Application.EnableEvents = False ActiveCell.EntireRow.Select vRows = Application.InputBox(prompt:= _ "How many rows do you want to add?", Title:="Add...
  6. N

    Insert row and drag/copy above formulas

    ****** http-equiv="Content-Type" content="text/html; charset=utf-8">****** name="ProgId" content="Word.Document">****** name="Generator" content="Microsoft Word 12">****** name="Originator" content="Microsoft Word 12"><link rel="File-List"...
  7. N

    Insert/Delete rows when a cell is filled/blank

    Hi, I am a VBA beginner and very new to this website. I want to thank you in advance! Thanks. :smile: Trying to create a friendly main worksheet for individuals when they open up the document. Description with snapshots of my worksheet: I have a list of names in the A column in...
  8. S

    AfterInsert in Excel?

    Is there an equivalent to Access's AfterInsert event? Or some other equivalent method? Here's what I'm trying to do... On a protected sheet, I have user entry colums on the left which feed protected calculated columns on the right. I want to insert a brand new row (by normal Excel method...
  9. P

    Merge Cells insert rows

    Hi I am haveing probems inserting rows through a range of merged cells. I can do the task normally. Select row insert row. However if I record the action I do not get the same result when I run the code. I know that merged cells are the bain of VBA and the two generally do not get on. Firstly is...
  10. I

    Inserting Rows....in large spreadsheet (part 1)

    Tackling a project......ill keep my questions seperate (as i have another question related to this spreadsheet) on to the question.. .... I have an excel spreadsheet from a Vendor with 1000+ rows of data. What Id like to/need to accomplish is insert 24 rows in between each row of exisiting...
  11. I

    insert multiple rows

    How can I insert multiple rows ie(20000) by entering a range or a from row and a to row.
  12. T

    Inserting blank rows between each line

    Happy Friday Everyone. I'm in 2007 and need to insert a row between every other line in a 30,000+ row document. To illustrate what I need: A1 full of data A2 want blank row A3 full of data A4 want blank row This is what I have: A1 data A2 data A3 data A4 data I appreciate any insight...
  13. M

    Insert rows question

    I have a spreadsheet that contains a table. In column C There is either a Y or an N. I have some code that deletes all the Y's and blank rows. I now need to insert 100 rows starting from the last row containing an N in column C. The code i have so far inserts 100 rows but inserts it ahead of...
  14. M

    Macro to insert a specified number of rows, please

    Hi, I need a macro that will start from a specified point in a spreadsheet and then will insert a number of rows based on a value in column Y. Sample data: <TABLE style="WIDTH: 1171pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=1561 border=0 x:str><COLGROUP><COL...
  15. M

    Getting a macro to compare to lines of data.

    I have the ability to populate a report in excel, giving me two months worth of data for employees one after the other - if theres only one line then the employee is new. E.G Excel WorkbookABCDEFGH5Employee No.Employee NameSalaryBasic DaysBasic HoursBasic PayBounty PaymentBounty Payment...
  16. P

    VBA for inserting and formatting

    I have a spreadsheet, and I have managed to get the right code that inserts a row below the current insertion point: Sub InsterRow() 'Insert row below active cell ActiveCell.Offset(1).EntireRow.Insert End Sub This also adds the right formatting and conditional formatting to the new row, but...
  17. B

    VBA code to insert rows meeting a condition

    Hi, I'm trying to insert a bit of code into my existing click button macro to insert a row based on a condition being met and then insert a formula into the resulting blank cell. Range to look at = L1:L1000 Condition = "=IF(LEFT(R[-1]C,13)=""ORCSW FRM ***"",""insert row below here"",""go to...
  18. bowlinbd

    Sheet Protection Question

    I have a protected worksheet in which A1:L1 contain headers. I want to allow the inserting of both rows and columns; however, I don't want to allow the insertion of columns between A:L or the insertion of rows above row 1. I don't really care what happens to the columns after L or the rows...
  19. undemane

    Check value and insert row

    I have data in a worksheet (say row1, row 2, row 3, etc.), and column D has a number in it. I want to check that number. If it is 0 to 6, do nothing; if it is between 6 & 12, I want to insert a blank row (row #2); if it is between 13 & 18, then add two rows (row2, row3), and so on. What...

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