How to Repair Dll Error Code In a Simple Way?: [Anwsered] 2003 vs. 2007 Color Conversion

Tuesday, March 15, 2016

[Anwsered] 2003 vs. 2007 Color Conversion

2003 vs. 2007 Color Conversion

My workbook started in Excel 2003, but is now working in Excel 2007. The below code is working so far as no errors is concerned; however, instead of background colors, I'm getting numbers in the cells. Looking around, I understand these are the new colors
for 2007. How do I get the cells to show the required colors instead of a number? The cells are formatted date.
Private Sub OptionButton5_Click()
    If Range("X29") <> False Then
        Range("AF29:AI29") = RGB(255, 255, 204)
        Range("AD29:AN29") = RGB(255, 255, 204)
        Range("AF31:AI31") = RGB(242, 242, 242)
        Range("AF29").Select
    End If
End Sub

Anwsers to the Problem 2003 vs. 2007 Color Conversion

Download Error Fixer (Free)

Another problem, the colors are coming up correct; however, I'm also getting numbers, like 13434879 in the yellow cells, which are displayed as #########. How do I resolve this?

Open Action Center by clicking the Start button Picture of the Start button, clicking Control Panel, and then, under System and Security, clicking Review your computer's status.

Make sure your computer has at least the minimum amount of random access memory (RAM) required to run the program that is displaying the error. Look for the program requirements online or in the packaging information.

Recommended Method to Repair the Problem: 2003 vs. 2007 Color Conversion:

How to Fix 2003 vs. 2007 Color Conversion with SmartPCFixer?

1. Click the button to download Error Fixer . Install it on your computer. Open it, and it will perform a scan for your system. The junk files will be shown in the list.