Compare Formats

[wilro85]

Is there a way to check if two cells are formatted differently?

I'm trying to use this:

                If oSht.Cells(i + 10, 6).Format <> oSht.Cells(i + 11, 6).Format Then
                    GoTo SkipBlanks
                End If

But I get an "object doesn't support this property or method" error.

[Palmetto]

Cells have a several format properties. You need to specify which of the format properties you want to compare.
Example:

If oSht.Cells(i + 10, 6).NumberFormat <> oSht.Cells(i + 11, 6).NumberFormat Then