I use makros to make a gantt Diagramm with a line for a day.
The work is done in Excel mostly. However the cells contains Formulars.
I use the Makros mainly to copy and paste a row.
I do this, because I want to protect the formulas against deletion.

The row is a constant.

Is there a way to save the content of the row in VBA. So i don't need to copy and paste rather then put in a new line and write text, formulas and colors????

thanks for your help

(somehow I can not paste and I can not attach my excel sheet either. So I show you a screenshoot. Actually I copy the first grey row, and paste it below. When I could "generate" a row with the proper content and formula of the source row it woud be much better)
codeexcel.png
tabelle.png
gantt.png