Hi,

I'm trying to change the background color on a cell at runtime with VB6 but I'm getting a subscript out of range error.. Can someone help me..? :)

Here is my code:

    'Populate Excel Cell
    With objExcel

        ' Reverse color to black on Carton Cell
        If FinishedCarton = TotalCarton Then
            .range("B3").Interior.Color = 0
        End If


    End With

Thanks!

=======================
Strange and crazy, but everything is possible

__________________
=======================
Strange and crazy, but everything is possible