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
Bookmarks