Converting cell colors to hex code

**DimlerJ** · 09-23-2007, 07:13 AM

Hi everyone!

I have attached a picture of how my document looks: one column of colors and right next to it, a column of color names. I want the colors from the colors column to be replaced with their hex code.

Ex:
#ffffff | white
#000000 | black

Does anyone know how can I do that?

**VBA Noob** · 09-23-2007, 08:09 AM

Maybe some code

Select your range then run macro. Link shows you were to place code

http://www.contextures.com/xlvba01.html#Regular

Please Login or Register  to view this content.

VBA Noob

**DimlerJ** · 09-23-2007, 01:52 PM

It works!!

Thank you very much VBA Noob, I have searched alot for something like this but couldn't find anything. Thanks again!

**VBA Noob** · 09-23-2007, 01:59 PM

Glad it helped

Code adapted from this site

http://www.mvps.org/dmcritchie/excel/colors.htm#chart

VBA Noob

Converting cell colors to hex code

LinkBack

Thread Tools

Rate This Thread

Display

Converting cell colors to hex code

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions