clear pattern but not gridlines

  • Thread starter Thread starter bob
  • Start date Start date
B

bob

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
 
Back
Top