Thread: Interior color disappears
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
The Code Cage Team[_102_] The Code Cage Team[_102_] is offline
external usenet poster
  
Posts: 1
Default Interior color disappears

In the beginning of the row code you are setting whole ranges of rows
back to xlNone, so everytime you run this code all those rows are reset,
to check if thats your problem use ' before each line and then run the
code and see what happens.


--
The Code Cage Team

Regards,
The Code Cage Team
http://www.thecodecage.com
------------------------------------------------------------------------
The Code Cage Team's Profile: http://www.thecodecage.com/forumz/member.php?userid=2
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=29472

Reply With QuoteReply With Quote