formulas after insert row
I am a beginner. After I successfully insert a row to my
spreadsheet I noticed that my spreadsheet formulas did not
carry down into the new cell. Is there a way to remedy
this issue? My code is as follows:
Do
If IsEmpty(ActiveCell)= False Then
ActiveCell.Offset(1,0).Select
ActiveCell.EntireRow.Insert
End If
Loop Until IsEpty(ActiveCell)=True
I also noticed that the new row is inserted after my first
row of data (not a big issue). Is there a way to insert
the new row as the first data row in my spreadsheet? I
tried renaming my range to "A5" from "A6", this worked but
it also carried my header formatting along with the row
insert. Thanks.
|