Thread: Colorindex referencing
View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.programming
gtslabs[_2_] gtslabs[_2_] is offline
external usenet poster
  
Posts: 15
Default Colorindex referencing
This is what I have but it still takes some time to run

showcolorindex = Cells(j, 8).Interior.ColorIndex
Cells(j, 18).Interior.ColorIndex = showcolorindex

Reply With QuoteReply With Quote