|I am looking for help with VBA code in excel. I am no VBA professional my any means but I think what I need shouldn't be too complex. I am trying to create a spreadsheet that will allow a user to fill color in numbered cells in one group of cells and then use a command button to automatically fill the same color to corresponding cells in a group below. I had come across the post below and that was exciting because it looks like it can be done but this code will not work for the way my numbered cells are laid out in the worksheet. I would love to send the file if someone is willing to take a look and help. Thanks!! Heidi|
DerbyDad03 had posted this at http://www.computing.net/answers/of...
"Run this and each cell in C12:AF17 will be filled with the same colors as C5:AF10 on a cell by cell basis.
In other words, for each cell in C5:AF10, the cell 7 rows below it in the same column will be filled with the color of that cell.
For Each myCellColor In Range("C5:AF10")
myCellColor.Offset(7, 0).Interior.ColorIndex = _