Is there a way to copy the formulas into the format when inserting a row between 2 rows, like such:

Range("E11:N" & addRowCount).Select
Selection.Insert Shift:=xlDown, CopyOrigin:=xlFormatFromLeftOrAbove

I want to not only copy the original "xlFormat" from "Above", I would like the "formulas" to be copied in the process. Is this possible?

Thanks

SPAM/Advertising Virus/Spyware/Malware danger Other Term of Use or Code of Conduct violation Child exploitation or abuse Harassment is any behavior intended to disturb or upset a person or group of people. Threats include any threat of suicide, violence, or harm to another. Any content of an adult theme or inappropriate to a community web site. Any image, link, or discussion of nudity. Any behavior that is insulting, rude, vulgar, desecrating, or showing disrespect. Any behavior that appears to violate End user license agreements, including providing product keys or links to pirated software. Unsolicited bulk mail or bulk advertising. Any link to or advocacy of virus, spyware, malware, or phishing sites. Any other inappropriate content or behavior as defined by the Terms of Use or Code of Conduct. Any image, link, or discussion related to child pornography, child nudity, or other child abuse or exploitation. In your case, if you prefer to use VBA, you can get some ideas from the following articles according to your situation:

Copying formula to the next row when inserting a new row

How To Autofill Formula When Inserting Rows In Excel?

However, if the above information doesn’t help and you need further assistance on this, considering VBA is beyond our support scope, I can help you move this thread to Excel/Microsoft Office Programming/Office 2019 category where has more professional members, we also welcome anyone who has the related experience to share ideas here, we appreciate your contribution.

Please feel free to post back if you have any concerns.

Best Regards,

SPAM/Advertising Virus/Spyware/Malware danger Other Term of Use or Code of Conduct violation Child exploitation or abuse Harassment is any behavior intended to disturb or upset a person or group of people. Threats include any threat of suicide, violence, or harm to another. Any content of an adult theme or inappropriate to a community web site. Any image, link, or discussion of nudity. Any behavior that is insulting, rude, vulgar, desecrating, or showing disrespect. Any behavior that appears to violate End user license agreements, including providing product keys or links to pirated software. Unsolicited bulk mail or bulk advertising. Any link to or advocacy of virus, spyware, malware, or phishing sites. Any other inappropriate content or behavior as defined by the Terms of Use or Code of Conduct. Any image, link, or discussion related to child pornography, child nudity, or other child abuse or exploitation.