Thread: Finding Cell Interior Colour of First Cell in Column
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Lonnie M. Lonnie M. is offline
external usenet poster
  
Posts: 184
Default Finding Cell Interior Colour of First Cell in Column
Hi, the folowing line of code will place in a variable the integer
value of the interior color of the first cell in the column of a range
called 'NmdRnge":

myColor = Cells(1, Range(NmdRnge).Column).Interior.ColorIndex

HTH--Lonnie M.

Reply With QuoteReply With Quote