Hello,
After much hair pulling i have decided to turn to the forums....I am very new to VBA, and know little but need a macro to copy the format and formulas of 3 selected rows and to paste them below. After the rows are pasted, i would also like for the bottom two rows inserted to automatically be hidden.

Ultimately what i am doing is creating a Gantt Chart using conditional formatting (yes i know there are easier option) that my boss has requested.
The way my file works is the first row is inputted by the user, the second and third row are equal to the first row. This allows for a task and timing excel file with completion status. The problem is not the Gantt conditional formatting, my problem is copying the above format of 3 rows and pasting below, and the bottom two of those 3 rows to be hidden automatically. I fear some of my problems may also be coming from merging cells vertically....which i hate (why is there no center across selection vertically.......different topic)

Please, i need any help or advice...Look forward to what you guys have to say!


Capture.JPG
Capture1.JPG