insert row code

[ryan_law2000]

Im looking to have vba code that will:

Insert a row
but continue on the formula in order from the cells above and below

I have formulas in columns
E - F - I

Those are the only columns i want the formula to entered in the new inserted row (but must be the next row in the formula not a exact copy)

I also need another code that will remove the row and fix the formulas to match the row

Hopefully i explained this good enough

Thanks!

 

[venkat1926]

the question are not clear to me

suppose the data is like this (see column G)

Excel Workbook
	A	B	C	D	E	F	G	H
1	4	16	20	4	67	31	35	13
2	43	67	28	65	21	76	36	3
3	58	29	54	7	71	48	22	19
Sheet1

now try this macro on this sample sheet. is this what you want

Sub test()
Dim j As Integer
For j = Range("A1").End(xlDown).Row To 1 Step -1
If Cells(j, "G") = Cells(j, "E") - Cells(j, "F") - 1 Then
Cells(j + 1, "G").EntireRow.Insert
Cells(j + 1, "G") = Cells(j + 1, "E") - Cells(j + 1, "F") - 1
End If
Next j
End Sub

 

[ryan_law2000]

I have tried this code and all i get is a debug at
"If Cells(j, "G") = Cells(j, "E") - Cells(j, "F") - 1 Then"

Anyone have a way to fix this?

 

[venkat1926]

did you try the macro on my sample sheet or in your original sheet. is there any difference in configuration. post a sample of your sheet

 

[ryan_law2000]

I have tried the original code that you posted and it didnt work.
I have never posted a sample of my sheet before, how do i do this?