clear pattern but not gridlines
 

i have a macro that coppies to a sheet & sets col colors.
i have another macro that copies to the same sheet but does not color the
colums.

i use the ISBLANK(C5)=FALSE statement to set a color if number found for
first macro but not used in the 2nd macro.

my problem seems to be i have to remove the pattern from the final sheet.
the temp sheet is created without a pattern but but is copied to a final
that still has colors; how do i clear a pattern off the final sheet but
maintain gridlines.

thanks

clear pattern but not gridlines
 

cells.Interior.ColorIndex = xlNon

--
Message posted from http://www.ExcelForum.com