View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default 1004- Unable to set the hidden property of the range class

I tested this. When any cell on row 2 does NOT match the color of the cell
on row 189 the column will become hidden. I understood this to be what you
wanted. You said 189 and now you say 180? Please FULLY explain your desires.



--
Don Guillett
SalesAid Software

"Darin Kramer" wrote in message
...


Not sure if we progressing...It doesnt get stuck... but produces the
wrong result ie it just matches colours in row 2 with colours in row
180. I need it to match colour of cell selected when macro run with
colours visible in row 180...

Regards

d

*** Sent via Developersdex
http://www.developersdex.com ***