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...

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...

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...

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...

****** 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"...

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...

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...

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...

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...

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

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...

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...

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...

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...

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...

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...

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...

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...