View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
jfcby jfcby is offline
external usenet poster
 
Posts: 33
Default Sheet Tab Color, Excel 2000 & 2003

Hello,

On worksheet("config").range("I3:I58") I have 56 of the color numbers
listed. Since I need certain ones I can use either the cell reference
or I can hard code them into an array.

All I need is to specify a tab color for each worksheet when the macro
is run either in an array or cell rreference.

Thank you for your help,
jfcby