Clear cells with white font

[prat1507]

Hi

I've been trying to clear the cells with white font, I've been using the below code:

    XLSheet.Range("A1:M55").Select

        For Each Cell In Selection

        If Cell.Font.Color = rgb(255,255,255) Then

        XLSheet.Cell.Clear

        End If

        Next

But this is not working. Please help.

Regards

Pratyush

[tresesco]

This should have been asked in an Excel forum.

Try like:

Range("A1:M55").Select

        For Each Cell In Selection

        If Cell.Font.Color = RGB(255, 255, 255) Then

        Cell.ClearContents

        End If

        Next

End Sub

[jonathandienst]

This is not really a Qlik issue. I suggest that you post this in an Excel/VBA/VBscript forum.

[prat1507]

Hi All

I'm using this in qlikview to edit the excel which I've been creating, writing a macro in qlikview is very different from wrtiting it in the excel itself, hence I'd posted this in qlikview community.

Regards

Pratyush