Trasparent color excel vba 2007 not working

[valgo54]

Hello
I have this problem with this macro.
The first 5 rows contains description, the user insert data starting from row number 6
Rows 1 , 3 and 5 , they contain user information , are colored in yellow.
Why during insert data row 6 is trasparent color , row 7 is colored in yellow, row 8 trasparent color, row 9 in yellow and so on ( one row trasparent, one row yellow). I want to have for all data inserted into the rows trasparent color. in attachemnt the excel file with macro to renaim in .xlms. My excel version is 2007.
Thanks

Here is is the code

Please Login or Register  to view this content.

[Leith Ross]

Hello valgo54,

This change to your macro will clear the cells in column "A". However, it will not change the cell color. Rows 1 through 5 will remain the same.

Please Login or Register  to view this content.

[valgo54]

Hello Leith for your answer
Supposig to have rows 1, 3 and 5 with yellow color. After I ran your macro this clean corretly all the rows with values starting from row 6. Now if I enter again values starting from row 6 I have row 6 with trasparent color, row 7 in yellow, row 8 traparent color , row 9 yellow color and so on.
Do you have any idea for that
Thanks