how to solve too many different cells formats?

[jackni]

Hi, everyone,
I want to show all kinds of colors (256*256*256=16,777,216) in one Excel worksheet. The VBA code as follows:
Dim i, j, k, i1
Sub a()
Sheet1.UsedRange.Clear
i1 = 1
For i = 0 To 255
For j = 0 To 255
For k = 0 To 255
Cells(i1).Interior.Color = RGB(i, j, k)
Cells(i1) = Str(i) & " " & Str(j) & " " & Str(k)
i1 = i1 + 1
Next
Next
Next
End Sub

When I run the sub, here incounter "too many different cells formats".Can Excel extend memory to solve the problem. Thank you very much!!!

 

[Comfy]

From here: https://support.office.com/en-gb/ar...67c00b05040f?ui=en-US&rs=en-GB&ad=GB&fromAR=1

Your code won't work as you exceed the number of rows

Worksheet size

1,048,576 rows by 16,384 columns

<tbody>
</tbody>

Colors in a workbook

16 million colors (32 bit with full access to 24 bit color spectrum)

<tbody>
</tbody>

Unique cell formats/cell styles

64,000

<tbody>
</tbody>

Why on earth would you want to show 17 million colours??

That's way too many for a person to review.