Thread: Color Variation
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
joel[_932_] joel[_932_] is offline
external usenet poster
 
Posts: 1
Default Color Variation


Pick 20 different shade in the macro. Don't use colorindex, instead
select more colors. Convert the shades to hexidecimal to help you get
the inbetween shades


MyColor = 10053375
RedShade = int(MyColor/(256*256))
GreenShade = int(MyColor/256) mod 256
BlueShade = MyColor Mod 256


--
joel
------------------------------------------------------------------------
joel's Profile: http://www.thecodecage.com/forumz/member.php?u=229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=198482

http://www.thecodecage.com/forumz