[bemiddy]

hey all
Id like to insert a line into excel and i would like it to auto fill somehow with the proper formula. like the cells around

is that possible to insert a line with it being already formatted?
thanks

[Advertisements]

It depends on exactly what you are after. There are several ways to do this. It is possible to simply insert the row and then copy and paste (formula) from a previous row or you can achieve this by writing VBA code to do the whole thing automatically. You have to consider things like cell reference (relative or absolute) etc.

HTH
"O"

[Octagonal]

It depends on exactly what you are after. There are several ways to do this. It is possible to simply insert the row and then copy and paste (formula) from a previous row or you can achieve this by writing VBA code to do the whole thing automatically. You have to consider things like cell reference (relative or absolute) etc.

HTH
"O"

[bemiddy]

It depends on exactly what you are after. you can achieve this by writing VBA code to do the whole thing automatically. You have to consider things like cell reference (relative or absolute) etc.

how would I do it with vba code?

[Octagonal]

Are you familiar with VBA coding? If you aren't, writing code for what you are asking in your first post can be a little tricky.

Below is an sample of code to insert a row.

Sub InsertRow()
Dim NumOfRows
NumOfRows = InputBox("Enter the number of rows required to be inserted.")
Range(ActiveCell.Offset(0, 0), ActiveCell.Offset(NumOfRows - 1, 0)).Select
Selection.EntireRow.Insert
End Sub

Here is a good example of the code for inserting rows and formulas.

I wont go into coding any further here as that topic belongs in the Programming sub- forum.

HTH
"O"

[bemiddy]

thanks
that site really helped!!