View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jamal Jamal is offline
external usenet poster
 
Posts: 26
Default Search for cell color, copy values in other columns

Hi everyone,

I am trying to put together a tool that can can search, column by column,
for a certain background/fill color (yellow), and then copy/paste the
value/text in various columns of the same row for each instance of yellow
background colored cells, into another worksheet.

I think I know how the first part of this problem can be solved (searching
for and identifying the background color cells), but how can I code to
copy/paste the values in specific cells?