VB to color code Excel cells

**canoe22** · 09-15-2012, 01:46 PM

I have inherited an Excel Workbook and have never seen it before. It is a work schedule and employee names are entered into cells that represent what days they will work. I found a VB app for this worksheet that defines a range of cells and then runs an "if" statement that compares the value (name) of the cell to constant values in the statement and assigns a background color to that cell. My first task after receiving this is to enter the next work period schedule. To do this I copied the current work schedule and pasted it in to the right of the current work schedule. The problem I have is that the cells are no longer colored after I paste it but the font color was not lost. I checked the VB app and determined that I am within the range defined.

I don't know VB so I am lost as to why I don't get color. Can anyone help me?

See the attachment for VB code example and worksheet example showing what was copied (colored) and what was pasted (black & white).schedule example.docx

**WasWodge** · 09-15-2012, 03:30 PM

Can you post the actual sample spreadsheet.
If you click the "Go Advanced" button then you will see a paperclip icon, if you click on that a box will appear that will allow you to attach the workbook.

**canoe22** · 09-15-2012, 04:17 PM

Thanks for your help WasWodge. I have attached the problem sheet. It was part of a large workbook that has data I should not pass around. I copied this sheet out and into a new workbook. I hope everything went with it.

**WasWodge** · 09-16-2012, 02:35 AM

Just to update this post for anyone else reading this postI have PM'd the OP with a bit more detail of what I tested but the basic finding is that it is an issue with the sheet itself and not the code.

I copied the data as values into another sheet and then put the code in that sheet and it runs correctly in the new sheet.

I haven't managed to find out what is wrong with the original sheet.

**canoe22** · 09-16-2012, 01:28 PM

Thanks again WasWodge for all your help. I have been able to create a new workbook and copy all the sheets from the old workbook into the new one and then create a new sheet with the VB code from the old sheet and I now have a working worksheet.

I am considering this issue resolved and will mark it so as soon as I determine how to do that. This is my first time using this forum and I am very happy that I did.