Transforming a color to digital value

Last update on December 5, 2008 01:22 PM by jak58
Published by jak58

Transforming a color to digital value







You can make use of this macro to get the color code: 

Sub distri_color()
  Dim i
  For i = 1 To 12
    Worksheets(1).Range("C" & i).Value = Worksheets(1).Range("B" & i).Interior.Color
  Next i
End Sub



'Replace 10 by the number of rows you want to use.
'Replacing the I in the column that you want to use for the result (color code).
'Replace the B by the column containing the color you want to filter.
Best answers for « Transforming a color to digital value » in :
VB6 Finding the RGB values of a color ShowVB6 Finding the RGB values of a color Dim R as integer Dim G as integer Dim B as integer Sub FindRGB(Col As Long) R = &HFF& And Col G = (&HFF00& And Col ) \ 256 B = (&HFF0000 And Col ) \ 65536 End Sub Note: Here...
How to convert a numeric value into english Word? ShowHow to convert a numeric value into english Word? To convert a numeric value into eng. Word, here is the formula you will need This is a post from the forum, thanks to rajput391 Below code enter in excel sheet: 1. Press Alt+F11 >...
[VBA] A function that returns the color of an active MFC Show[VBA] A function that returns the color of an active MFC This function returns the value of the active format in conditional formatting. With the function below, two values can be returned. Mode = 0: the value of Interior.ColorIndex...
Download Digital Photo Recovery ShowMore digital Free Art Photograph Recovery is a powerful tool allowing to find and to restore pictures incidentally abolished by a card memory. It works with all types of card memory. Files can be recovered from a formmated card or even from corrupt...
Download Easy Photo Transfer Show
Download Driver Canon Digital IXUS 750 Show
Worksheet - Cells ShowThe Concept of a Cell A "cell" is the intersection between a line (horizontal) and a column (vertical) on a worksheet. Thus, the name of the line combined with the name of the column gives the cell's coordinates (the term address is sometimes also...
DTS (Digital Theater Sound) ShowDTS standard DTS (Digital Theater Sound) is a digital sound coding standard created by Universal. Compared with the Dolby Digital standard, DTS uses four times less compression and digitises sound at 20 bits instead of 16. Therefore, DTS's sound...
Representation of real numbers and integers ShowRepresenting a number in a computer Representing (or encoding) a number means to express it in binary form. Representing numbers in a computer is necessary in order for it to be able to store and manipulate them. However, the problem is that a...
They need your help