Thread: Copy Rows that have a Green font color to another worksheet
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
mrdata[_2_] mrdata[_2_] is offline
external usenet poster
  
Posts: 1
Default Copy Rows that have a Green font color to another worksheet

Hi Tom

The "G" in column (P) refers to the row font color Green
I'm using this to paint the row font colors without having to do it
manualy

The code you wrote copies all the rows to the correct worksheet
I only want to copy the green rows

Thanks for your help


--
mrdata
------------------------------------------------------------------------
mrdata's Profile: http://www.excelforum.com/member.php...o&userid=17899
View this thread: http://www.excelforum.com/showthread...hreadid=511536

Reply With QuoteReply With Quote